I am a beginner in PHP and therefore I need your help with the following.
I have created in MySQL a table 'scores' with columns user_id and score.
Now, I want to present the user_ids ordered by their score...
I have done the folowing
$query="select user_id from scores order by score desc"; $result=mysql_query($query); $num_results=mysql_num_rows($result); $row=mysql_fetch_row($result); for ($count=0; $count<$num_results; $count++) echo row[$count];
I expected to see all the user_id however I don't get anything at all. Can anyone help me with this?