PHP, MySQL & Images

[Ace_Mace]

Howdy,

I have sucussfully learned and outputed a product list from MySQL for my products.... or that's what I thought :rolleyes:

My newbie problem turns out to be the... Image Nightmare for the past couple of weeks!

I have added a BLOB field in the database and loaded up the images in MySQL. I am sure because I see the byte size for each image entry in the database. Now, when I try to output this with PHP, it gives me garbage on the screen for that field. Here is part of my code:

while ($row=mysql_fetch_array($result)) {

/////////// Results ///////////////////////
echo("

<tr>
<tr><td colspan=4>$row[pics]</td><td></td></tr>
<tr><td></td><td><font color=#FFFFFF>$row[name]</td></tr>
<tr><td></td><td><font color=#FFFFFF>$row[type]</td></tr>
<tr><td></td><td><font color=#FFFFFF>$row[comment]</td></tr>
</tr>
");
//////////////////////////////////////////////

All columns print out fine on the screen except for the "pics" field as I mentioned that it looks scary on the screen with all the garbage letters.

I would appreciate any help with this. Thanks a lot

[jonno946]

as far as i know you cant echo a mixture of text and images.

check out the header() function in the PHP manual.

i'd recommend only outputting your text on the script, and then do something like <img src="get_pic.php?image_id=1">, however on get_pic.php set the header to the type of the image like this:

header('Content-type: image/jpeg'').

probubly not explained in the best way (in a rush) so search the forum for more information on this.

Jonno

[thorpe]

i would think you would be better off storing the images in a folder, the filepath in mySQL, and then using the filesystem functions to retrieve your images.