Hello Friends .
i have a problum with MySQL query .
i hav a table called "Products" with 'pID' , 'pTitle' , 'downloads' now i want to get the most downloaded product from the table .
i wrote this line of query
$sql = mysql_query("SELECT * FROM Products ORDER BY downloads DESC LIMIT 1")
its getting a product which have 99 downloads but there is more products which are downloaded more than 100 times .
so basically i want to ask why the MySQL is assuming the 99 as Highest .
i am using MySQL 5.0 and PHP 5.4