> > Well, I have this: > > > > $result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum ASC'); > > if u're trying to use variables like $table in the query (which i think u are), they need to be in double quotes : " " not single quotes. so the line should be: $result=mysql_query("SELECT * FROM $table ORDER BY lastname, street, housenum ASC"); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php