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: Select all
<cfoutput query="bla" group="AlbumName">
#AlbumName#
<cfoutput>
#ListOfTracks#
</cfoutput>
</cfoutput>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: Select all
//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>");
}Thanks!!!