I do believe it is a MySql question!!

What's wrong with the old standard way as:

$result = mysql_query("
        if (last_name is NULL,'zzz end',last_name) as last_name_sort
FROM   new_miatapix
ORDER BY last_name_sort
LIMIT $page, 20");

Good Luck.. HTH..
Jason Soza wrote:

> I thought this was a MySQL question, or something that could be solved using
> a creative SQL string, but after looking through the MySQL manual, I don't
> think I can handle this with the database alone. According to the manual,
> MySQL always sorts NULL values first - I want them last. I have a last_name
> field that sometimes contains people's last names, sometimes they choose not
> to enter their last names. I want those who don't enter a last name to end
> up last on the list.
> Right now I have: $result = mysql_query("SELECT * FROM new_miatapix ORDER BY
> last_name LIMIT $page, 20");
> Am I going to have to do two queries here, then store them somehow using an
> array? It seems like I'm going to have to do one query to get all NULL
> values for last_name, then do another query to get all NOT NULL values for
> last_name, but how would I handle that after I get it to PHP?
> Or can I use some PHP function to sort $result to place all NULL values
> last? I'd check the PHP manual, but it seems to not be responding well at
> the moment.
> Thanks,
> Jason Soza

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to