RE: [PHP] Re: Using PHP for NULLs

2002-05-20 Thread Jay Blanchard
[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_

RE: [PHP] Re: Using PHP for NULLs

2002-05-18 Thread Jason Soza
Thanks for the help! I spent more time looking at IFNULL() when I should've just been looking at IF(). Thanks again, sorry for the off-topic! Jason Soza -Original Message- From: Dan Koken [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 18, 2002 11:16 AM To: [EMAIL PROTECTED] Subject: [PHP