Posted by lorento on 06/08/06 07:04

"webmechanic" wrote :
> I was able to insert images into mysql stored as binary data.

because its a binary data you can just echo the content data. Try like
this :

<?php
$query = "SELECT blobfield FROM table WHERE ????";
$result = mysql_query($query, $dbc);
$result_data = mysql_fetch_array($result, MYSQL_ASSOC);


header("Content-type: image/jpeg") ;
echo $result_data['blobfield'];

?>

regards,

Lorento
--
http://blogs.deshot.com
http://www.mastervb.net
http://www.immersivelounge.com

[Back to original message]