[RESOLVED] Images in a loop

olovell

Hi,

I have retrieved a set of records from a database and have stored the results in an array and then display the results in a loop. The thing is that it works except that my image field is not displaying. This is my code I am doing this in PHP.

while($row = mysql_fetch_array($bidResult))
	{
		$row = mysql_fetch_array($bidResult);
		echo "Name: "; 
		echo $row['fname']; 
		echo " ";
		echo $row['lname']; 
		echo"<p>";
		echo $row['image'];		
                        }

The image in the database is stored as the path to the image location. eg ../images/home/1.png

I know that my code for displaying the image is wrong but I do not know the correct method. Please HELP.

bradgrafelman

Sounds like a simple HTML issue... if you want to display an image, you'll want to output an <img> element.

olovell

Could you show an example of how to echo it exactly?

Weedpacket

The same way you're outputting everything else in your code.

cretaceous

like this:
echo "<img src='".$row['image']."'>";

olovell

Thanks it worked. Those singe and double quotes and dots(.) are what were getting me. thanks agaqin

bradgrafelman

Also note there are many other ways of writing this:

echo "<img src='".$row['image']."'>";

Few examples:

echo "<img src='$row[image]'>";

or:

echo "<img src=\"$row[image]\">";

or:

printf( '<img src="%s">', $row['image'] );