[robbydweb]

I have a mysql database of entries with one column having a number value called score.
is there sql command or a way to take the top 5 scores from the database and display them into an array?

[xtremenw]

Originally Posted by robbydweb

I have a mysql database of entries with one column having a number value called score.
is there sql command or a way to take the top 5 scores from the database and display them into an array?

"select value, score from table order by score desc limit 0,4"

try the above. i am not very good with asc or desc, so you might need to switch it. Also, 0,4 should show 5 entries... Also, replace value & score & table with the correct information for your sql table.

[James Talbot]

Its quite easy an easy way to do what i think you want.

PHP Code:

$sql = mysql_query("SELECT * FROM table ORDER BY something");



// Set rank to 0



$rank = 0;



while($data = mysql_fetch_array($sql)) {





$rank = $rank++;



?>



<p><?=$rank;?></p>

<p><?=$data['username'];?></p>



<?

}

?>

Obviously update that so it suits your needs.