Re: display order by field value?
| From: | - \[ Paul Ferrie \] - | Date: | Sun, 18 May 2003 20:08:08 +0000 |
| Subject: | Re: display order by field value? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-148117@lists.php.net to get a copy of this message | ||
Soz guys simple newbie mistake
the field was not set to INT
Cheers
"- -" <info@innovativedesigns.org.uk> wrote in message
news:20030518192446.96693.qmail@pb1.pair.com...
> 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
>
>
>