DB binary data

Anon

greetings,

This is todays problem, Im storing some pics in a db and want to get them out and display them based on the date match from the db. BUT How do I retrieve them out of the db and present them in the html page.. I cant get it to work?(inside a while loop to display all the pics on one page?)

Thanks

peter

Anon

I know there are tutorials on here and on Devshed.com that show you how to do this and this very question has been answered 100s of times on both forums. Please spend a little time searching and you'll surely find your answer. I do not know how to do it.

---John Holmes...

Anon

John,

I appreciate your response, but I certainly have searched the issue on this site. It is not a general "how to" issue. It is the article on this site that is the culprit.. They explain how to present a single pic on a blank page.. What good is that? who displays information in this manner? NOT that there article is not appreciated rather they may have overlooked a simple factor.

Your point is valid as I see you often assist ALOT of people! (including ME :0) )

Thanks
peter

Anon

You want to have a script that just makes one picture on a blank page...You then use it like so:

or, even pass it some info...

---John Holmes....

Anon

Okay..just reread your question. Assuming you've got a php page that can read the binary data out of the database and create the nec. headers for an image...

$query = mysql_query("select id from pictures");
while (list($id) = mysql_fetch_row($query))
{
echo "<img src=\"your_pic_page.php?id=$id\">
}

Apply the nec. formatting of course, tables or whatever...but hopefully that gives you an idea.

---John Holmes...

Anon

John,

Wont have a chance to try your advice for a week (out of the country till monday) but It appears you have pointed me in the right direction...

Thanks again!!

pete

Anon

And you don't have a laptop loaded with everything you need??? What kind of programmer are you!?!?

j/k...have fun!

---John Holmes...

Anon

Yea right now if they only paid as much as they work ya.

🙂

Pete