add a order by but i don't know where to put it

[skoff]

Hi,
this my query :
$result = mysql_query("SELECT First,Last,Games,Goals,Assists,Points,PIM,PlusMinus,Shots,Min,Hits FROM players WHERE team = '" . mysql_real_escape_string($_GET['team'])."'") or die(mysql_error());

everything is working fine, the only thing is that I want to add a order by points desc but i don't know where to add it in my code? Because i want that when we see the table they are from the best to the worst pointers.

thanks for your help

[Anyango]

$result = mysql_query("SELECT First,Last,Games,Goals,Assists,Points,PIM,PlusMinus,Shots,Min,Hits FROM players WHERE team = '" . mysql_real_escape_string($_GET['team'])."' ORDER BY Points DESC") or die(mysql_error());

[skoff]

thks a lot it's working! ;)