Hello,

I am trying to populate a photo gallery web page with dynamic data. The input is coming from a jump menu on the previous page that is populated dynamically. When a user chooses a photographer from the jump menu I want the gallery_detail page to display thumbnails and image details for that photographer. I can get the URL to include a request string, ie. gallery_detail.asp?photographerID=102, but how can I use this to populate the page with the correct info from the database. Thanks for any help.

Regards

Paul

Post a breakdown of the table structure of the DB you've created.

- Doc

Progress is made by the discontent.

Hi Doc, thanks for replying. The two main tables in the DB are 'images' and 'photographers'.

Images holds fields, imageID (prim key), photographerID, image title, thumbURL, imageURL and some other detail fields such as shutter speed, aperture etc.

Photographers holds fields, photographerID, name, membershipID, and other details such as address etc.

A relationship is made between them with photographerID. Thanks.

Paul

Sorry it's taken me so long...Been tied up.

I created a down and ditry app that I think is what you are trying to accomplish. Go to the folowing link. If this is what you're trying to do let me know and I'l post the code...

www.daveblohm.com/dmxzone/photo_gallery/

- Doc

Progress is made by the discontent.

Hey Doc,

You are spot on. The only thing I want to try is to show each large image on the same page, ie.with thumbnails showing ready for the viewers next choice without having to use the back button, but I'm sure I can do that. Another idea was to show each large image by showing a layer as each thumbnail was clicked rather than a new page loading each time.

Great stuff tho' Doc, look forward to the code. Your a genius.<img src=../images/dmxzone/forum/icon_smile_shock.gif border=0 align=middle>

Regards Paul

What about something like this...

www.daveblohm.com/dmxzone/photo_gallery/pic.asp?artist_id=1&pic_id=330#img330

The above is an implementation of the thumbs navigation I wrote for the image gallery section of my personal website...

www.daveblohm.com/galleries.asp

Edited by - daveblohm on 02 Mar 2007 01:03:30

Yeah, thats the type of thing Doc. I'll look forward to seeing the code. Thanks.

Paul

I've packed the two files (index.asp and pic.asp) in a .zip file.

You can get them at www.daveblohm.com/dmxzone/photo_gallery/code.zip

Let me know how it works out and if you have any questions.

- Doc

Progress is made by the discontent.

Thanks Doc,

Got the files, I'll give it a go this evening. Have a great weekend. Regards,

Paul