Getting images from Database

[pingu_letters]

OK, so this is really getting on my nerves now!

Does anyone know how to display an image retrieved from a MySQL database without having to run the query from a seperate 'php' page, with the necessary JPEG headers declared?

I have a table that stores an image and its name & description so I don't want to have to query the database twice to display the details:
1- Retrieve image details (index.php)
2- Retrieve image (image.php)

Anyone got any ideas?

[erick_w]

make a certain function to get and display the image then you can simply call the function from each page... (you just have query once, that is on the function)

[pingu_letters]

Sorry, I meant only one query to get:
- textual information
- name
- description
- image

[erick_w]

One query to get textual information, name, description and image? Well, it depends on your database table design. If those information are in a single table, do something like this:

SELECT textual_information,name,description,image FROM table_name WHERE condition...