[PHP/MySQL] How to readout Highscores from DB

[mvbcrs]

I've made a test in flash. The flash file creates 2 vars (naam and score).
I write them in a tabel named test.
Then i want to read the results out in a page. Starting with the highest score. Doh 🙂

This is how i try to do it now:

$query = mysql_query("SELECT * FROM test ORDER BY score DESC"); 
while ($obj = mysql_fetch_object($query)){  

$obj = mysql_fetch_object($query);
echo "
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td width=\"50%\">$obj->naam</td>
    <td width=\"50%\">$obj->score</td>
  </tr>
</table>";
}

But it only displays the last result.
How do i need to change the code to make it read all results from the tabel (test) and display them in ordered by score starting with the highest score?

[kristianblom]

You initialize the $obj variable two times.

try this...

while ($obj = mysql_fetch_object($query)){

echo "
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"50%\">$obj->naam</td>
<td width=\"50%\">$obj->score</td>
</tr>
</table>";
}

[xblue]

how many record do you currently have? if more than two, there may be other problems, but here's one:

you don't need the line
$obj = mysql_fetch_object($query);

as it is now, you fetch 2 rows, but only use one. remember, the mysql_fetch_... functions get you one record every time they are called, and while ($obj = mysql_fetch_object($query)) already is one call.

EDIT: too slow again..., but I think the idea is pretty much the same 😉

[mvbcrs]

Originally posted by kristianblom
You initialize the $obj variable two times.

try this...

while ($obj = mysql_fetch_object($query)){

echo "
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"50%\">$obj->naam</td>
<td width=\"50%\">$obj->score</td>
</tr>
</table>";
}

Thnx man. No it works fine!