Hey Ya'll,
when I have a string like this in my PHP script :
$result = mysql_query("select * from table_two ORDER BY var2");
The output shows table ordered by var 2 on alphabet
but that means that when var2 is empty in some rows of the database, that these are shown first......
How do I make the output show the list on alphabet,(a -> z) but with the empty's last??
I hope my question is very unclear!?
Niels,
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
when I have a string like this in my PHP script :
$result = mysql_query("select * from table_two ORDER BY var2");
The output shows table ordered by var 2 on alphabet
but that means that when var2 is empty in some rows of the database, that these are shown first......
How do I make the output show the list on alphabet,(a -> z) but with the empty's last??
I hope my question is very unclear!?
Niels,
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->