[snip] I do believe it is a MySql question!! What's wrong with the old standard way as:
$result = mysql_query(" SELECT *, if (last_name is NULL,'zzz end',last_name) as last_name_sort FROM new_miatapix ORDER BY last_name_sort LIMIT $page, 20"); $result = mysql_query("SELECT * FROM new_miatapix ORDER BY last_name LIMIT $page, 20"); [/snip] And then there is the very old standard; SELECT * FROM new_miatapix ORDER BY last_name DESC LIMIT $page 20 HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php