RE: [PHP] Re: Using PHP for NULLs

[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

RE: [PHP] Re: Using PHP for NULLs

: [PHP] Re: Using PHP for NULLs 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); Good Luck.. HTH.. Dan