I have a membership and I'm trying to show which members have the most referrals in a list from most to least and eventhough I'm using asc, it is still showing the list of members in random order, ie 10,2,7 -when i would like it to be 10,7,2.... Can anyone tell me what I'm doing wrong in my code?
Thank you in advance!
require('include/config.php');
$db = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname,$db);
$sql = "SELECT * FROM users where rcount>1 ORDER BY 'rcount' ASC";
$result = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($result);
print("<table><tr><td>Member</td><td>Referrals</td></tr>");
if($num != 0)
{
{
while($row = mysql_fetch_array($result)) {
$username = $row[0];
$rcount = $row[10];
print("<tr><td>$username</td><td>$rcount</td></tr>");
} } }
print("</table>");
?>