[RESOLVED] Arrange help

[darko886]

Hello, I got help earlier on arranging a table in descending order. This is the code I am using

$result = mysql_query( "SELECT * FROM `table` ORDER BY `Pts` DESC" )

Now what I want it to do is, if there are 2 fields with the 'Pts' value equal, for it to order them individually by the 'GD' value

so for example, Team A and Team B both have 10 points but Team A has 7 GD and Team B has 5 GD so Team A would come before Team B....

Thanks
Darko

[NogDog]

$result = mysql_query( "SELECT * FROM `table` ORDER BY `Pts` DESC, `GD` DESC" );

[darko886]

THANKS A LOT!!! GREAT SUPPORT 😃 worked PERFECTLY 🙂