Re: mysql + PHP
| From: | Satyam | Date: | Thu, 15 Jun 2006 06:36:09 +0000 |
| Subject: | Re: mysql + PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-238032@lists.php.net to get a copy of this message | ||
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@cxrus.com>
To: <php-general@lists.php.net>
Sent: Thursday, June 15, 2006 8:14 AM
Subject: [PHP] 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