how to display the images, which are in mysql database?

[sangeetha]

Hi,

I tried to display images using the anchor tag, its working but i would like to display the image from the database directly.

thanks in advance

[Weedpacket]

Then use an <img> tag.

[zcollvee]

okay....
I dont think the anchor tag can display images...

$query = "SELECT image FROM images";
$result = mysql_query($query);
while(list($image)=mysql_fetch_row($result)){
echo '<img src="'.$image.'">';
}

[djjjozsi]

i think its better:

$query = "SELECT image FROM images";
$result = mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_assoc($result))
{
echo '<img src="'.$row['image'].'">';
} 

[sangeetha]

thankyou so much and yes its possible,
<a href="image/<?php echo $qry['filename']; ?>" > download </a>
this is how i made to display my images from table...