Re: Query Help!
| From: | David Robley | Date: | Thu, 08 Apr 2004 09:12:46 +0000 |
| Subject: | Re: Query Help! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33796@lists.php.net to get a copy of this message | ||
jusa_98@yahoo.com (Jerry) wrote in
news:20040408090556.90296.qmail@web41201.mail.yahoo.com:
> Hi Everyone, Happy Easter to you all.
>
> I have this query, reasoning for posting on this
> Mailing List is under it. :)
>
> SELECT
username , score FROM
> round" .
> $round_number . " WHERE 1
> ORDER BY score DESC LIMIT 0, 30
>
> Is there a way to make it output the $round_number -1
> (minus one number)?
>
> I need this to be a temp. meassure as I only need the
> number previous to the current $round_number for a few
> days. Is there a way in the query I can subtrack the
> value by 1 and change it later when I want to show the
> current round?
>
> If it's too much hassles I can add $prev_round_number
> and change the values each week but thought there
> might be another way.
Have you tried
SELECT username , score FROM round" .
($round_number -1) . " WHERE 1
ORDER BY score DESC LIMIT 0, 30