first entry does not display

[seanisean]

my problem is that using this code i am only able to display the last two entrys of the database that have the condition "c", the first entry will not display, or basically 2 out of the 3 possible database entrys display

<?php
	$plant_pics = mysql_query('SELECT * FROM plant WHERE alphabetical = "c"');
	$pic_array = mysql_fetch_array($plant_pics);
	WHILE($pic_array = mysql_fetch_array($plant_pics))
	{
		$picture = $pic_array['file_name'];
		$name = $pic_array['name'];
		$alphabetical = $pic_array['alphabetical'];
		$plant_id = $pic_array['file_id'];
		echo("<a href=\"plantdetail.php\"><img src=\"../$picture.jpg\" alt=\"$name\" width=\"190\" height=\"127\"/></a>");

}
?>

sorry if this has been answered elsewhere, i had a good search but to no avail... thanks in advance

sean

[Installer]

// In this line you fetch the first result row:
$pic_array = mysql_fetch_array($plant_pics);
// But don't do anything with it.

// In the next line 
WHILE($pic_array = mysql_fetch_array($plant_pics))
// you loop through the rest of the results, 
// and in the loop block you display them.

You could do either this 🙁 :

$plant_pics = mysql_query('SELECT * FROM plant WHERE alphabetical = "c"'); 
$pic_array = mysql_fetch_array($plant_pics);
$picture = $pic_array['file_name']; 
$name = $pic_array['name']; 
$alphabetical = $pic_array['alphabetical']; 
$plant_id = $pic_array['file_id']; 
echo("<a href=\"plantdetail.php\"><img src=\"../$picture.jpg\" alt=\"$name\" width=\"190\" height=\"127\"/></a>"); 
WHILE($pic_array = mysql_fetch_array($plant_pics))
{ 
    $picture = $pic_array['file_name']; 
    $name = $pic_array['name']; 
    $alphabetical = $pic_array['alphabetical']; 
    $plant_id = $pic_array['file_id']; 
    echo("<a href=\"plantdetail.php\"><img src=\"../$picture.jpg\" alt=\"$name\" width=\"190\" height=\"127\"/></a>"); 
}

or this 🙂 :

$plant_pics = mysql_query('SELECT * FROM plant WHERE alphabetical = "c"'); 
WHILE($pic_array = mysql_fetch_array($plant_pics))
{ 
    $picture = $pic_array['file_name']; 
    $name = $pic_array['name']; 
    $alphabetical = $pic_array['alphabetical']; 
    $plant_id = $pic_array['file_id']; 
    echo("<a href=\"plantdetail.php\"><img src=\"../$picture.jpg\" alt=\"$name\" width=\"190\" height=\"127\"/></a>"); 
}

[seanisean]

cheers installer,

you are indeed the boss! i best not give up my day job just yet.
a very nice and simple answer so i went for your first block of code....... just kidding😉

regards

sean