mysql + PHP

From:	weetat	Date:	Thu, 15 Jun 2006 06:14:10 +0000
Subject:	mysql + PHP
Groups:	php.general
Request:	Send a blank email to php-general+get-238026@lists.php.net to get a copy of this message

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