URGENT - PHP not working..

[Luke]

Basically, I have this code;

<?php
$query = "select *
from `winningflight`
order by points desc";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo $row['flight'];
?>

This is the table


It always shows A, not B

[Chippiewill]

I personally can't see a problem with the code, maybe add limits. Also the MySQL bindings just got deprecated, you may want to use the MySQLi ones instead.

[Luke]

I personally can't see a problem with the code, maybe add limits. Also the MySQL bindings just got deprecated, you may want to use the MySQLi ones instead.

I had a limit, but that didn't work:/ And I don't 100% know what that means

[Chippiewill]

"LIMIT 0,1" on the end of your mysql query will return just one result starting at the first result.

[Luke]

I sorted it using MAX, but thanks Chippie!

[Zak]

In future (when your table gets a little more info) you may want to limit the query to the field names you want to return to optimise performance