MySQL Numbers

[Robbie]

I have a database where users send in a name like 'Dave' and I want to display the top 5 names voted for. I know I could use mysql_num_rows to get the number of times a name has been voted for, but how would I display the top 5 names using mysql_num_rows?

+rep to helpers

[Robbie]

right, ive sorta figured it but it displays it like this

Red has been voted for 2 times
Red has been voted for 2 times
Blue has been voted for 1 times

the code is

$query = "SELECT * FROM `colours` ";
$result = mysql_query($query) or die (mysql_error()."<br />Couldn't execute query: $query"); 
$numrows = mysql_num_rows($result);
 
echo '';
while($row = mysql_fetch_array($result)) {
 
$color = $row["color"];
 
$query2 = "SELECT * FROM `colours` WHERE `color` = '$color'";
$result2 = mysql_query($query2) or die (mysql_error()."<br />Couldn't execute query: $query"); 
$numrows2 = mysql_num_rows($result2);
 
 
echo "$color has been voted for $numrows2 times<br>";
 
} 

any help? thanks