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!