hi , not working .
The empty value still sorted first.
Thanks.
Satyam wrote:
perhaps this will work:
Select country , name from tbl_chassis order by ifnull(country,'zzzz')
didn't try it.
----- Original Message ----- From: "weetat" <weetat.yeo@xxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Thursday, June 15, 2006 8:14 AM
Subject: mysql + PHP
Hi all,
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem of the sql statement is that , if there are empty value
in country field , it be sorted first .
How to do sorting the empty value last
? I can cp() function to do this ? or any mysql function to use?
Thanks
- weetat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
