Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Unanswered: Retrieving data from a temporary MySQL table in PHP

    Fixed part of that problem by getting rid of the temporary table (I'm stupid and didn't think of that. lol)

    Code:
    SET @rank := NULL;
    SELECT * FROM (SELECT @rank := COALESCE(@rank + 1, 1) AS rank,id,username,((knight+ranger+mage)+4*(treasury+lumbermill+mine+forge+farm)) AS score FROM new_users ORDER BY score DESC) AS rankings;
    Last edited by Sent1nel; 07-05-07 at 18:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •