Printable View
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 ;)
right, ive sorta figured it but it displays it like this
the code isQuote:
Red has been voted for 2 times
Red has been voted for 2 times
Blue has been voted for 1 times
any help? thanksPHP Code:$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>";
}