Php Seperation of Data issue

[azrag]

alright I am pulling data from the database using a key variable as my search limitation to get the right data. Here is my problem I want to pull out all the songs made by a particular artist and organize and separate them and put them automatically where the album is. I know this isnt very clear so I will give a quick example (by the way this is a lyrics site)

http://mysite.com/artist.php?id=yellowca rd

ok id = yellowcard this will be used in a mysql query to limit down all the yellowcard songs in the database

Artist ---------------- Album ----------------------- Song
yellowcard / Paper Walls / Fighting
yellowcard / Lights and Sounds / Lights and Sounds
yellowcard / Paper Walls / Light up The Sky

ok above is the results pulled from the database notice the seperate albums now here is what I want to do with this.

(pretend below is a page result organizing the albums with the songs associated with them)
Album Paper Walls
-----------------------------
Light up The Sky
Fighting

Album Lights and Sounds
------------------------------------
Lights and Sounds

Once I get the results how do I seperate them like what I just did all help would be greatly appreciated

[authorblues]

At 8/30/07 12:12 AM, azrag wrote: appreciated

when you call the data, you could always just use "ORDER BY album"

[DFox]

If I understand what you mean, you can do something like this in your SELECT statement:
ORDER BY Album ASC

Then, when you loop through the results, just keep track of what the last album was, and if the current value is different, it means you're up to a new album.

[azrag]

well I knew about that but I want it to display the album name and the cover I have stored while listing the songs right next to it. im still searching though for a way

[elbekko]

Use a control var:

$a = '';
while($row = mysql_fetch_assoc($result))
{
if($row['album'] == $a)
echo $row['album'];
// Rest
$a = $row['album'];
}