[SOLVED] Losing 1st row with a mysql_fetch_array() While loop

[Plain Flailing]

The aim of the following code is to display the latest thumbnails in a gallery. It should display 4 thumbnails, but only displays 3, missing out the most recent (the one that comes first in the query results).

 

$query = "SELECT ID_PICTURE, thumbfilename FROM smf_gallery_pic ORDER BY date DESC LIMIT 4";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);

echo '<b>New Pictures:</b><br />';

while($row = mysql_fetch_array($result)){
echo '<a href="http://www.mysite.com/index.php?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="http://www.mysite.com/gallery/', $row['thumbfilename'], '" /></a>';
}

 

I have checked that the thumbnail file exists. It just isn't added to the HTML output.

 

Anyone know what I'm doing wrong?

[Fidsah]

Array numbers start at zero. Are you taking that into account?

[ratcateme]

you dont need this line befor the loop

$row = mysql_fetch_array($result);

that takes the first row then when your loop starts $row is overwriten with the second remove that line and your code will work

 

Scott.

[Plain Flailing]

Brilliant, that's solved the problem. Thanks!