how do i select this list

From: Date: Wed, 15 Mar 2006 16:32:53 +0000
Subject: how do i select this list
Groups: php.general 
Request: Send a blank email to php-general+get-231954@lists.php.net to get a copy of this message
The query below gives me a list of usernames with the highest point score at the top. There is also a secondary points list which i need to use to rank players if there POINTS are the same. ie: username points margin paul 26 24 mark 23 11 john 23 10 I want to rank 'john above 'mark' as his margin points are lower. I can't rank by margin alone and i need ranking by points (Desc) first then by lowest margin. how can i change this statement below to achieve this. Thanks $query = mysql_query("SELECT * FROM leaderboard WHERE comp_id = $comp_id ORDER by points DESC ");

« previous php.general (#231954) next »