Please help

[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

NOTE what i am trying to do is something similar to internet dating sites where u can search 4 ladies/men. profiles contain images and the searcher will view all the profiles at once.

[mogster]

The php of the image-fetching is in a standalone script, and linked in the img-tag, yes?
<img src="yourscript.php?pic_id="<?PHP echo $pic_id; ?>">
The method above won't work, because you can't do header() after echoing the img-data for the first picture. So the only way is to do the picture-data-treatment in a standalone script, and link it by img-tag.

As for linking the car-data with the picture-data:
You should create a field in the car-data table (int) and call it pic_id or something. This would then contain the picture_id, and will function as the link between the data and picture.
If you set it to default at 0, this may be used to lookup wether or not the car has a picture. If the car has a picture, just echo the img-tag, and the standalone picture-script will do the rest 😉

knutm