Hello, I am a newbie to php and to this forum...I'm posting this question after hours of troubleshooting with no found solution. My background is in ColdFusion which i am fairly fluent with. I'm basically trying to do the php equivalent of this coldfusion code... [code] <cfoutput query="bla" group="AlbumName"> #AlbumName# <cfoutput> #ListOfTracks# </cfoutput> </cfoutput> [/code] The output i'm going for is: Album Name 1 Track 1 Track 2 Track 3 Album Name 2 Track 1 Track 2 Track 3 Currently, the php code i'm using is this: [code] //Discog query $sqldisog = "SELECT Albums.*, Tracks.* FROM Albums LEFT JOIN Tracks on Albums.Album_Name = Tracks.AlbumName WHERE ArtistName = '$aName'"; $resultdiscog = mysql_query($sqldisog) or die("Query failed: " . mysql_error()); while ($rowdiscog = mysql_fetch_array($resultdiscog)) $category[$rowdiscog["Album_Name"]][] = $rowdiscog["title"]; //album header info foreach ($category as $cat=>$title_array) { echo("<br/><b>$cat</b> ($resultdiscog[Album_Year]) <br/>"); echo("Label link <br/>"); //album tracklist foreach ($title_array as $title) echo("$rowdiscog[TrackOrder]) asdf<br>"); } [/code] This php code is outputting the Album name correctly (which is currently set to $cat) and is even outputting the correct number of "asdf<br>" for each album, but for some reason i cant output any of the other data returned in the query by using...$rowdiscog[ColumnName]. Can someone please show me how to do this properly? Thanks! Thanks!!!