Query Help!
| From: | JeRRy | Date: | Thu, 08 Apr 2004 09:05:56 +0000 |
| Subject: | Query Help! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33795@lists.php.net to get a copy of this message | ||
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.
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com