PHP/ MySQL ranking Question

[motoman]

Greeting All,

I have a an mysql database that feeds my php site. In the database i have scoring tables.

Currently i run this query.
$overall=mysql_query(" SELECT *, SUM(250w_total) AS 250w_total, SUM(250e_total) AS 250e_total, SUM(450_total) AS 450_total, SUM(round_total) AS round_total, members.Username, members.city, members.state, members.country, pick_date FROM sx14sp_mem_picks INNER JOIN members ON sx14sp_mem_picks.user_id = members.user_id GROUP BY members.Username ORDER BY round_total DESC LIMIT $start, $per_page");

As you can see this query returns me an array that i build into a table 1st threw whatever the last rank is with paging.

What i can't figure out. Is there a way to to query to just get the rank of a single user?

basically i want to display the rank of any given user in the results table sx14sp_mem_picks.

Example: When the user logs on i want to retrieve the rank of that user and store it(session) for use across the site.

Any ideas would be appreciated.

Cheers!

[motoman]

i got i think.

SELECT FROM (
SELECT s., @rank := @rank + 1 rank FROM (
SELECT user_id, sum(round_total) TotalPoints FROM sx14sp_mem_picks
GROUP BY user_id
) s, (SELECT @rank := 0) init
ORDER BY TotalPoints DESC
) r
WHERE user_id = 2654