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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php