[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
