Fetching images from MySQL

[Darren Lewis]

I'm trying to display an image on a non-vb php page. The image is stored in a forum post as an attachment.

I can nearly get it to work.

I've got this query

PHP Code:

$fetchimage=$DB_site->query("SELECT attachment.filedata FROM attachment WHERE attachmentid='$attachmentid'"); 


I then set up this array

PHP Code:

$image = mysql_fetch_array($fetchimage); 


Problem is that I can't get it display the image. If I echo $image I just get "Array"

How can I get the image displayed? It's a .jpg attachment.

Thanks.