Hi there,

http://www.aylesford.kent.sch.uk/ht...magegallery.asp

As you can see from the link above (which is my work!!), I need to transfer the hard-coded html to a database as i've been told the number of images will increase 10-fold!!! Click on a thumbnails to see it's comments.

1. I need to display all the images in a database, ideally restricting them to 16 per page. The tricky bit is I have 3 field headers... Name (being the image filename), Folder (being the folder the image is stored in), and Comments (being a single line of text describing what the image is.

2. Each displayed image will be a hyperlink to a bigger version, which when opened, displays the Comments containted in the databse for that image.

I'm pretty comfortable with number 2 as i've done a similar thing on another project... but if someone could point me in the right direction to accomplishing number 1, it would be very much apreciated!

This will be a single databse, with multiple category named tables containing images that are relevant to that category.

Thanks/...