apheli0n

Thanks! I was able to get it to work from that code...now i can define all the variables I want from the query by using this code: [code] $album_title = "null"; while ($rowdiscog = mysql_fetch_array($resultdiscog)){   if (is_null($album_title) || strcmp($album_title,$rowdiscog['Album_Name']) !=0 ){          // Album header info   $album_title = $rowdiscog['Album_Name'];   $album_year = $rowdiscog['Album_Year'];<br />   $album_label = $rowdiscog['LabelName'];   $labelurl = $rowdiscog['LabelURL'];       echo "<br><b>$album_title</b> ($album_year)<br>\n";   }   // Track listing     $TrackName = $rowdiscog['TrackName'];   $TrackNum = $rowdiscog['TrackOrder'];   echo "$TrackNum) $TrackName<br>\n"; } [/code]

Thanks for your help...though the cleaned up code you posted doesn't work quite right...its almost a step backwards because it repeats the album name for each track in the album. Right now, with the original code i posted, the output is like this... Album Name 1 asdf asdf asdf asfd asdf asdf asdf Album Name 2 asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf So its outputting the number of rows for each album correctly, but i just cant figure out how to output the track names from the query.

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!!!