I was able to insert images into mysql stored as binary data. How do I
retrieve it. Please provide thorough explanation. Thanks.

"webmechanic" <dmitrymar@yahoo.com> wrote in message
news:1149693940.744768.258410@g10g2000cwb.googlegr oups.com...[color=blue]
> I was able to insert images into mysql stored as binary data. How do I
> retrieve it. Please provide thorough explanation. Thanks.
>[/color]

Do your SELECT:

$query = "SELECT blobfield FROM table WHERE ????";

$result = mysql_query($query, $dbc);
$result_data = mysql_fetch_array($result, MYSQL_ASSOC);
$img = imagecreatefromstring($result_data['blobfield']);

---

Just lookup the exact function parameters as that is just off the top off my
head...

Norm
--
FREE Avatar hosting at www.easyavatar.com

"webmechanic" wrote :[color=blue]
> I was able to insert images into mysql stored as binary data.[/color]

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