Re: insert & select image in mySQL

> Try this code. It assumes you are already connected to the database. > Usually, I put that script in something like database.inc and just do an > include. > > <?php > mysql_connect ("mysql_server", "username", "password"); > mysql_select_db("database_name"); > $sql = mysql_query("SELECT image, type FROM table_name WHERE pid='$id'"); > $file = mysql_fetch_row($sql); > header("Content-type: $file[1]"); > echo $file[0]; > ?> > > pid is the picture id. I'll assume you'll have an index or something in your > database setup. > Now, type is based on the extension of the file really. If filename.gif is > uploaded, it is assumed that the header type is image/gif. > > How do you use this? > > Save this little script as a seperate file. It is now the image file. > Observe: > <img src="foobar.php?id=24"> > > Now, assuming that the file you saved it as is foobar.php, the script will > fetch the binary data of whatever is at pid 24. > It doesn't run for me. I always got an eternal red cross in place of the picture I'm looking for...Any idea ? ---------------------------------- Stéphane Pinel 39, Rue du Docteur Heulin 75017 Paris (FRANCE) 33 1 53 11 05 77 33 6 08 94 63 16 spinel@noos.fr ----------------------------------