True Results help...
<?php
// Connect to the database
$db = mysql_connect("localhost","nisite","pw");
mysql_select_db (nisite);
// Ask the database for the information from the links table
$query = "SELECT * FROM downloads ORDER BY downloads DESC LIMIT 5";
$result = mysql_query($query);
// Now we print out the results, starting by making a table
echo ("");
while ($rows = mysql_fetch_row($result))
// Here we make the script keep making new rows until all the links in our database are shown, this is called a loop
{
echo ("<a href= 'file.php?id=$rows[0]'><font face= 'verdana' color='#000000' size= '1'><font face= 'verdana' color='#000000' size= '1'><B> ยป </B>$rows[1]</B> - $rows[4] Downloads.</a><br>");
}
// Finally we close off the table
echo "";
?>
Why is this not printing out the most downloads in order from highest to lowest... on the page it will print almost random entries...
