how to get the row number?

[Dave-42]

Hello everybody,

I`d like to ask you for help with the "PHP sort" function. I´m managing a database of hockey players and have created a table which can sort and order the players by their Name, games played, goals scored, assists, points, etc.
It would be great if you could tell me how to get the actual row number, everytime there is a new sort - I need this for the RANKING column.

Sorry for my english and thanx for your help.

Juraj Lovas

[Vinay]

have an auto incrementing ID field in your database and get that number ?

Regards,
Vinay Sahni
SitePoint Community Moderator
myPHPhost.com: mySQL 3.23, php4.0.3pl1, optimizer