Hello
OK, even though I'm a newbie I have managed to set up a 5000 photo record database and retrieve information from that database and display it in my web browser.

However, the only info I've been successful in displaying is the text info pertaining to the photo but I would like to display a photo (maybe 2 photos) along with the text info.

I will only be displaying one record at a time..when the page loads it will display a photo and all the text information about the photo.

I have read many articles on the web about not storing images in your database that it's better to store the URL to the image. That's fine by me I'll be glad to store them in a folder on the server.

But, in all the articles I've read I still haven't seen an explanation on how to do this. So, can someone tell me how to store the URL or hyperlink or whatever it is that will allow me to get an image to display.

I don't a link to the photo to be displayed but the photo itself.

I have managed to get this far by reading and taking some online courses on PHP and MYsql but none of them covered this. So any help will greatly appreciated I'm really stuck.

Background Info
PHP4.3.1
MYsql 4.1.9
PHPmyadmin 2.6

Thanks

Yah, you use your php to write some html like:
 <img src="$URL_OF_IMAGE" alt="comment">

The $URL_OF_IMAGE is the URL that you stored as a field in your database. The web browser that connects to this page then figures out decoding the image at that path for you.

You might want to take a look at the source of slooze (http://www.slooze.com ) which is a simple php photo album that works this way - I use it myself!

HTH

--
Don't Stand on your head - you'll get footprints in your hair. http://www.charlieharvey.org.uk

sorry, forgot to say the url should be in the format:

http://your_web_server_root/path/to/image.jpg

--
Don't Stand on your head - you'll get footprints in your hair. http://www.charlieharvey.org.uk

Hi Guys,

I'm having a similar problem. I'm new to phpmyadmin and mysql, etc. I've created my database and tables and now i want to add images to my tables. I too am happy to point to a url if my site will display the picture 'not' the url.
I've managed to display the image in phpmyadmin under the structure of the database, but I cann't get it to show on my webserver. The field I want the picture to be displayed in just shows the file path of the picture. Do I have to add that image source html code to Dreamweaver, or in phpmyadmin?
many thanks for your help, please be patient with me, i know very little about dynamic websites!

Cheers
Alison:)

Thanks :o)

I have it working. Thanks very much - I added the code like you said into the varchar field of the phpmyadmin and heypresto!!! Many thanks I'm over the moon!!! :D

Thanks :o)