display a single thumb per gallery
| From: | Ross | Date: | Sun, 27 Aug 2006 18:23:33 +0000 |
| Subject: | display a single thumb per gallery | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-241146@lists.php.net to get a copy of this message | ||
I have a database of images, http://www.thethistlehouse.com/db.jpg
What I want to do is select ONLY ONE image to display as a the image link
for that gallery. As you can see galleries are numbered dynamcially but
galleries can also be added and deleted so the galleries no's I have now (7,
8) will change. I have the code to display the thubnail but am stuck with
the query.
I want to use mysql and php to
(i) determine how many unique galleries there are.
(ii) Retrieve & display a single thumbnail from each gallery to act as the
link to that gallery
Ross
