growing frustration with images

Anon

I've decided to store images directly into mysql. I have been advised not to do this but can't figure out what else to do. Why for the life of me can't I pull the images back out!!!! Does anyone know what the best way to deal with these images is!? Should I go back to using pointers? If so, please give me an example of how to output the images correctly. Or, tell me what I've done wrong here...
<?
mysql_connect("","","");
$query="select * from ";
$result=mysql_db_query("",$query);
$rows=mysql_num_rows($result);

if($rows<1)
{
print "No Image";
}
else
{
$photo=mysql_fetch_object($result);
Header("Content-type:image/jpeg/gif");
$body=$photo->image;
echo $body;
flush();
}
?>

theslinky

umm... i dont' know whether you made a typo, but on this line, you did not specify the table:

$query = "select * from ";

it should be

$query = "select * from image_table"

or something like that.

-sridhar

Anon

I didn't want my info revealed... I'm aware that I have no login info or table name.

theslinky

Okay, i'm sorry for mistaking your code.

Hmm. have you tried executing this code in the MySQL processor? If you are on linux, have you gone into mysql (mysql -u user -p database) and tried out your query? perhaps the problem may lie there.

Also, are you sure that the proper image data is in the database? What is the datatype of the field? I usually use MEDIUMBLOB or LONGBLOB (any kind of blob should do)

Plus, I tried the code out. It works for me. Here is the output:

http://www.theslinky.com/phptests/image2.php

Also, here is the code:

<?php

mysql_connect("localhost", "xxxxxx", "xxxxxx");
$query = "SELECT * FROM banners WHERE bannerID = 1";
$res = mysql_db_query("phpads", $query);
$rows = mysql_num_rows($res);

if($rows < 1) {
print "No Image";
}
else {
$photo = mysql_fetch_object($res);
Header("Content-type: image/gif\n\n");
print $photo->banner;
}

-sridhar