number list
| From: | Bigmark | Date: | Sun, 20 Aug 2006 05:30:13 +0000 |
| Subject: | number list | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-240912@lists.php.net to get a copy of this message | ||
Hi, can anyone help me with this at all.
i have a table leaderboard with username points etc and can echo the scores
in asc order ok but what i want is to grab the scores and display a users
position using their session ID.
So if the scores are for example:
36 user3
22 user1
18 user4
12 user2
How do i show user 1's position on the leaderboard on their user login page.
here are the fields in table 'leaderboard'
ID
user_id
username
points
comp_id
email