Find out & print row number

[Nixon]

Hi, I have a mysql query which selects some rows in a certain order, I want to be able to select a row from some variables and then print what row number it is? Is there a way of doing this?

Thanks, Nixon.

[kevinsequeira]

yes there is, however your question is very vague, if you provide us with code snippets or tell us what you're trying to do in more detail then we can help you out

reg
kevin

[Nixon]

Well, if I have a database with 100 people in it. I also have a loggin script. When they log in there username and password is recorded to a session. Now, I want to look into the database with all the username and password info and order it by points, which I can do, but then i want to be able to find the row where the username and password that was logged into the session is and print that row number so its sort of like a ranking system. Hopefully.