# Seemingle simple PHP MySQL question

**URL:** <https://forum.kirupa.com/t/seemingle-simple-php-mysql-question/182136>\
**Category:** web dev\
**Created:** [March 15, 2006, 6:58pm UTC](https://forum.kirupa.com/t/seemingle-simple-php-mysql-question/182136 "2006-03-15T18:58:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sigepmest37](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@sigepmest37](https://forum.kirupa.com/u/sigepmest37)\
**Post date:** [March 15, 2006, 6:58pm UTC](https://forum.kirupa.com/t/seemingle-simple-php-mysql-question/182136/1 "2006-03-15T18:58:23Z")

</div>

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!