help with gallery design

[Talguy]

I want to make a main gallery page that displays every gallery on it with the first thumbnail from each gallery, how would I come about to do this

                        Evan

[bpat1434]

Read my article..... Create an online photo gallery

It's an easy intro into it. Adding the thumbnail to the gallery is an easy code modification. I suggest you read it at some point.

My demo and sources aren't up, but all the code is there in the article....

[Talguy]

i don't want to set up an extra directory for an album icon I want to get he first image name out of my mysql database and display it with the name of the photo album right under it and I do not know how to do this.

[Talguy]

I just want to select the first image for each album out of mysql database I don't know how to run a query that could do this

[bpat1434]

SELECT imagePath
FROM galleryTable
WHERE category = '$category'
ORDER BY id ASC
LIMIT 0,1

OR

SELECT id, imagePath, galleryName
FROM galleryTable
GROUP BY galleryName
ORDER BY id ASC

[Talguy]

so will this return 1 photo for every album

[bpat1434]

the second one will....