How to group entries in table according to one column

[eluser]cmgmyr[/eluser]
Then you can do something like this:

Code:

SELECT DISTINCT `album` FROM `albums` ORDER BY `album` ASC

I normally set up an "albums" page then a "photos" page. Once they click on an album then they will get directed to the photos page, which shows all of the photos for that album.