I am creating a photo gallery page for a site. The MySQL has 3 fields:
id - well...the id
path - photos/images.jpg
album - what album they are in ie Album1, Album2, Album3, etc.
For the part im working on i need to have a query for just one photo from each album ( it doesn't matter which photo), so that the user can pick which album they would like to look at.
Thanks in advance for your help!