need with a standing system

[skoff]

Hi! I want to make a kind of standing like for the nhl. So the thing is that in nhl you have conference and division. But the point where i block is that i need that when there's an egality in the points i need to go check which one has the most win. This is my query for right now it would really help if you could tell me what is the part for asking to "order by" win after ordered by points.

Here's my query :
SELECT * FROM standing where conference ='West' and division='Central' order by points desc

Thansk for your help! :)

[skoff]

up! :) i really need this information plz! Thanks a lot! :D
I tried :
SELECT * FROM classement where conference='Ouest' order by points,win desc

but it didnt take in consideration the column win...

[stargateanubis14]

what are all the columns you have set up? just giving us a query without much database structure wont help anyone else help you....

[skoff]

my table is name standing and this the list of my columns :
id,conference,division,team,win,lose,loseot,points

[skoff]

i would like to know at the same time if its possible to show number of each row in the result of my query. When i echo my result if my result give 8 rows i would like on each row to have
1
2
3
4
5
6
7
8

i know that i can use mysql_num_rows but the thing is that i dont want to show the number of rows that my result give but to have each number of each row

thanks! :D