display image from table

[hongnfox]

Hi,

I have a form where a user can upload an image, and this gets stored in the database as a filepath successfully. I just want to be able to display this image when I view the form again. Is this possible? I've searched the forums but couldn't figure out how to use headers or how to call an image tag correctly.

This is some of my code so far...

form.php:
<FORM enctype="multipart/form-data" action="sales_commit.php?id=<?php echo $_GET['id']?>&aid=<?php echo $agent_id?>" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="30000">
.....
<td>Image:<?php echo $image?><img src='images/"<?php echo $image;?>"'></td>
<td><INPUT type="file" NAME="image"></td>

processform.php:
I have no problems whatsoever uploading the file into my server.

What can I change in the form.php file?
Any help would really be appreciated, been trying to resolve this for a few days!

Thank you.

[xen01]

Guy,

That code is quite confusing, but the underlying concept is
that u save the file-location of the file to the database, then later on retrieve the image by echo'ing da' file-location.

Ne?

[phpsharma]

Get image

$query = "select Photo2, PhotoType2 from 
//print $query;
$result=@mysql_query($query);
while($d = mysql_fetch_array($result)){
     $data = $d[0];
     $type = $d[1];
}
Header("Content-type: $type");
echo $data;

show image:
<img src="getimg.php?id=<? print $id?>&num=<?=$num?>" border=0 >