[PHP] Re: how do i select this list

Mark wrote: THANKS THAT WORKED GREAT You might need this in the future: http://dev.mysql.com/doc/refman/5.0/en/index.html Thare are lot's of examples, also the problem you stated is described there. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- PHP Gener

[PHP] Re: how do i select this list

THANKS THAT WORKED GREAT ""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > $query = mysql_query("SELECT * FROM leaderboard WHERE comp_id = $comp_id > ORDER by points DESC, margin ASC "); > > Mark wrote: > >> The query below gives me a list of usernames

[PHP] Re: how do i select this list

$query = mysql_query("SELECT * FROM leaderboard WHERE comp_id = $comp_id ORDER by points DESC, margin ASC "); Mark wrote: > 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