how to get the nr of a row?

[GRooVeZ]

hi

 

im looking into matches with a match id and a player id, and i want as result in wich place the player ended

 

$playerresult=mysql_query("SELECT id,points FROM ffa_points where matchid=$matchid order by points desc");

 

can i directly select the nr of the row? or do i have to make a while loop, and count every time wich place he ended?

 

 

 

[.josh]

what does nr mean?

[smerny]

what is meant by 'wich place he ended'?

[gizmola]

Directly in mysql you can try this:

 

SELECT id, points, @row := @row + 1 as position
FROM ffa_points
JOIN (SELECT @row := 0) as t 
WHERE matchid = $matchid 
order by points desc

 

However, assuming you have to display the rows, you can also do it procedurally in your fetch loop and display the position that way.