[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_
bject: [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
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..
===
3 matches
Mail list logo
