Photo album

Question

User2140025385 posted

Hi,

I'm trying to create an album gallery, which works this way:

First, i have the album photos with description on each album under the photo, with a pager. ( that was done)

Second, when you click on a certain album, you see all photos related to this album only. 

I am using ACCESS DB. i just cant figure it out how to connect those data correctly, and how clicking an album will take me to the photos related only to it.

I would appreciate any help or samples for such a thing.

Thanks,

Basil

Answer 1

User241050104 posted

r u storing images in database?

if yes then can u pls provide ur databse related details?

Answer 2

User-1618234021 posted

hi

you have to make the photo albums links in such a way that when the use clicks on any of them you pass the album id (for example) to photos page. i.e

<a href='photo.aspx?albumid=1'>First Album Image</a>

<a href='photo.aspx?albumid=2'>Second Album Image</a>

so on...

Then on photo.aspx page load you can get the querystring parameter albumid and fire a query like :

"select * from photo where albumid=" & Request.QueryString("albumid")

Run the query, fetch the data and show it properly.

Answer 3

User2140025385 posted

i'm using access db. im not sure about the structure of the database, but i would appreciate ur help.

those are the fields ive created

albumdesc
albumphoto
albumtype
albumyear

galleryphoto
photodesc

Each album contains description, photo, type and year. Inside that album there is only photo and description.

Answer 4

User2140025385 posted

adeelehsan,

Shukran for your reply.

The problem is that the albums are added by some admin, so the number of albums is not known.

Answer 5

User-1618234021 posted

Hi

What I posted was a sample code. Just wanted to show you how it will work. Ofcourse you will fire a query and bind all the album records with some control. That control will produce the output like I posted.