display order by field value?
| From: | - \[ Paul Ferrie \] - | Date: | Sun, 18 May 2003 19:24:51 +0000 |
| Subject: | display order by field value? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-148111@lists.php.net to get a copy of this message | ||
Hi guys :)
Tonight i would likt to know hot to set the display order of data from mysql
with the field with the highest value being the first, i hope u follow.
here's what i have
$query = "SELECT wall_scr, username, hscr_d FROM forumUsers WHERE
wall_scr>0 ORDER BY wall_scr ASC";
wall_scr= number whatever
h_scrd = date set
username= well...
I would have thought that the query would return the highest value in the
wall_scr field, but it dosnt.
anyone
Cheers
P.S
It's a highscore table