who can help me sort this out

chishake

i have a table which contains images each with a unique id. my database is a project and viewers will have to view the images in the database thus they wont know the id. To be specific, the database contains two tables. one called cars with their various descriptiuons and another one with the fotos of the various cars. I originally wanted to use one datable for both the cars and their fotos but was unable to display the imges. i then decided to build to separate tables. one for the cars and the other for their images which i have to link when searching. the search critaria will be based on the car table. this is the code i used for the image table
$sql = "SELECT * FROM images";
$result = mysql_query ($sql, $db);
while(mysql_num_rows ($result) > 0) {
$row = @mysql_fetch_array ($result);
$image_type = $row["filetype"];
$image = $row["binary_junk"];
Header ("Content-type: $filetype");
echo "$image";
}
But when i try to display the output only the first image is displayed. I cant used any where condition here . as i said these images will be linked to the car table and then displayed. But there is a where condition in the car table. e.g WHERE car = AUDI AND PRICE = £1000 AND .... etc. Do u understand now? I will be very happy if anyone help me sort this out as its giving me headache.
i am using MYSQL.
thanks

statrat

not sure if i understand, but the "while(mysql_num_rows()....." loop will only process once. and the mysql_fetch_array() function returns one row at a time (i.e. your first row). so...

$sql = "SELECT * FROM images"; 
$result = mysql_query ($sql, $db); 
  while($row = @mysql_fetch_array ($result) ) { 
     $image_type = $row["filetype"]; 
     $image = $row["binary_junk"]; 
     Header ("Content-type: $filetype"); 
     echo $image; 
}

eriksmoen

the header() in the loop will generate errors... put it above the while statement instead of inside it.

also, $filetype is not defined... might also give you errors.