incorrect results from mysql_fetch_array loop

[tHud]

 

Currently I have 5 entries in my table.

 

Entring this query displays all five in the correct order.

 

SELECT * FROM products ORDER BY count DESC LIMIT 16

 

 

 

However, using this code, the first result is omitted and the last four are displayed.

 

 

$query="SELECT * FROM products ORDER BY count DESC LIMIT 16";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo '<div>';
while ($row = mysql_fetch_array($result))
	{
	echo '<div>'.$row[product].'</div> <div>'.$row[count].'</div>';
	}
echo '</div>';

 

Can someone help me find my error?

Thanks

[AbraCadaver]

Delete this:

 

$row = mysql_fetch_array($result);

You're fetching the first row and then throwing it away before the loop, why?

[tHud]

I don't know why. I guess it's code I routinely paste. 

 

However, I knew that I had read something about that in these forums but I was unable to find it due to the search function being unavailable.

 

It clearly shows a fundamental misunderstanding on my part.  I won't make that mistake again!

 

Thank you AbraCadaver.