|
|

mysql_connect("localhost", "red169859", "jkvm4za");
$query = "SELECT ArtistID, ArtistName FROM Artists WHERE ArtistID != 3 AND ArtistID != 4 ORDER BY ArtistName ASC";
$results = mysql_db_query("redlinerecords_com_au", $query);
$left = TRUE;
while ($r = mysql_fetch_object($results)) {
if ($left) { ?>
}
?>
$query = "SELECT Catalogue.CatalogID AS CatalogID, Title, Cover, Trackname, AudioFile FROM RealAudio, Catalogue WHERE Catalogue.ArtistID = $r->ArtistID AND Catalogue.CatalogID = RealAudio.CatalogID";
$results2 = mysql_db_query("redlinerecords_com_au", $query);
if (!mysql_num_rows($results2)) { ?>
No Sounds
} else {
while ($r2 = mysql_fetch_object($results2)) {
if ($r2->CatalogID != $currentCatalogID) {
$currentCatalogID = $r2->CatalogID; ?>
echo $r2->Title; ?>
} ?>
} // end else from r2 while
} // end else from "No Sounds" check
?>
|
if (!$left) { ?>
}
$left = !($left);
} //End r results while
?>
|
|