Hi, I have MySQL with a database of registered users.

Now I want to make a script where the users click on a certain link, and they'll get a point. For every time they click this link they will add one more point to their existing score.

After that I want to make a table that displays the 10 top scores of all the users.

How do I go about this?

Thanks

If you don't know how to write it. ...
















... Hire somebody

Hi, I want to rank my users for a high score.

I tried putting this query in MySQL:

$sql = 'SELECT * FROM users ORDER BY points DESC, username ASC LIMIT 20';

but got this reply:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = 'SELECT * FROM users ORDER BY points DESC, username ASC LIMIT 20'' at line 1

What have I done wrong? the table is called users and there is username and points in it.

Also, I've tested a few other queries with success, but I don't know how to actually show the ranking in a .php page. And I've looked everywhere and can't get an explanation of this.

Thanks

A php string is NOT a SQL query.

I'm very new to php and I hope this thread doesn't get locked aswell. I'm making a highscore table that will display my users in order of highest points. I've entered a query which seems to work, but the question still remains, where should I put it to display the information on a php page? I've tried putting it in a td table in <?php but it just shows an empty table.

SELECT
  ID, username, points,
  @prev := @curr,
  @curr := points,
  @rank := IF(@prev = @curr, @rank, @rank+1) AS rank
FROM
  users,
  (SELECT @curr := null, @prev := null, @rank := 0) sel1
ORDER BY points DESC
;

Thanks for any help!

of course, the php coding of it would be:

$sql  = 'SELECT'
        . '   ID, username, points,'
        . '   @prev := @curr,'
        . '   @curr := points,'
        . '   @rank := IF(@prev = @curr, @rank, @rank+1) AS rank'
        . ' FROM'
        . '   users,'
        . '   (SELECT @curr := null, @prev := null, @rank := 0) sel1'
        . ' ORDER BY points DESC'
        . ' ;  LIMIT 0, 30 ';