-
Sort by date
In this code:
$Sql = "select * from VisualBasicBank where BankID>=1";
$Result = mysql_query($Sql);
while ($Row = mysql_fetch_array($Result))
{
Echo "$Row[Date]";
}
I want to echo $Row[Date] but sorted by date.
What can i add to $Sql to do that ?
Thanks
-
change your $Sql statement to:
$Sql = "select * from VisualBasicBank where BankID>=1 order by date asc";
-
Thank you too much
But, please how to sort it by date (New date First)
-
cpradio had it right.
use his and place DESC in place of ASC
$Sql = "select * from VisualBasicBank where BankID>=1 order by date DESC";
-
ok
Thank you toooooooooooooooooo much.