need help about fetching image and other data

digital_plunder

m trying to fetch a image from mysql (blob) with header..here is my coding..."<?php
include("db.php");

$query=mysql_query("select * from table where id='3' ");
$row=mysql_fetch_array($query);
$r=$row['image'];
header("content-type:image");
echo $r;

?>"

i want to fetch another fields from the database with image....how it can possible?please help me...thanks in advance...

johanafm

You are allready fetching all fields, since you are using *, which you shouldn't. Specify the field names you actually want to retrieve.

Also note that you can't send more data than one single image when setting the content-type to image (and you are lacking /subtype, as in image/gif, image/jpeg), since that really means that all the content is supposed to be an image, not several, not image and text etc.

bradgrafelman

You should also add some error checking to see if [man]mysql_query/man indicated than an error occurred (and, if so, log the MySQL error message and perhaps even the SQL query as well) and if any rows were returned in the result set (because if not then you shouldn't be attempting to fetch any rows from it).

digital_plunder

u r right ..i have set header to display image...but i m saying that i want to fetch another fields on 1 page from database...like i m fetching now image only...but when i try to fetch"firstname,lastname and image name" from database on 1 page...page display only image not any another field like firstname or lastname...
"I m asking how it can possible on 1 page...that i can fetch image and another fields of the user from the database..can someone help me out...i want to fetch image from the database and dont want to use move_uploaded_files to move image to another folder..i want to put image in database also and want to fetch image and another fields from the same table from database....thx in advance....

bradgrafelman

The script you've shown is outputting the actual binary image data. As such, you can't output anything else.

The HTTP protocol only allows one "file"/object per transaction. if you send binary data, you can't send other data; you'd need to do that in the HTML document that links the user to this script.