[SOLVED] ORDER BY

[ronnie88]

<?php
include 'database.php';

$query  = "SELECT va, cash FROM virtuala ORDER BY cash ASC LIMIT 20";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo " VA Name :<b>{$row['va']}</b> <br>" .
         "Cash : {$row['cash']} <br>";
}

?>

 

How would I going about putting cash in order? from highest to lowest? thanks

[trq]

Exactly as you have done providing cash is one of the numeric field types.

[ronnie88]

thanks had to change asc to desc thanks again

[ronnie88]

thanks