Sort by date

[prokhaled]

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

[cpradio]

change your $Sql statement to:

$Sql = "select * from VisualBasicBank where BankID>=1 order by date asc";

[prokhaled]

Thank you too much

But, please how to sort it by date (New date First)

[scoutt]

cpradio had it right.

use his and place DESC in place of ASC

$Sql = "select * from VisualBasicBank where BankID>=1 order by date DESC";

[prokhaled]

Thank you toooooooooooooooooo much.