|
|

COMING SOON
mysql_connect("localhost", "red169859", "jkvm4za");
$query = "SELECT CatalogID, Artists.ArtistName AS Artist, Title, Cover, Released FROM Artists, Catalogue WHERE Artists.ArtistID = Catalogue.ArtistID AND Released > now() ORDER BY Released ASC";
$results = mysql_db_query("redlinerecords_com_au", $query);
if (mysql_num_rows($results)>0) { ?>
while ($r = mysql_fetch_object($results)) {
?>
|
Artist - $r->Title"; ?>" border="1" align="absmiddle">
echo $r->Title; ?>
echo $r->Artist; ?>
Released:
list ($year, $month, $day) = split('[- :]',$r->Released); echo "$day/$month/$year"; ?>
Info
|
} ?>
} else { ?>
Stay Tuned!
} ?>
OUT NOW
$query = "SELECT CatalogID, Artists.ArtistName AS Artist, Title, Cover, Released FROM Artists, Catalogue WHERE Artists.ArtistID = Catalogue.ArtistID AND Released <= now() ORDER BY Released DESC";
$results = mysql_db_query("redlinerecords_com_au", $query);
if (mysql_num_rows($results)>0) { ?>
while ($r = mysql_fetch_object($results)) {
$count = 0;
?>
while ($count < 4 and $r) {
$count = $count + 1;
?>
|
Artist - $r->Title"; ?>" border="1" align="absmiddle">
echo $r->Title; ?>
echo $r->Artist; ?>
Info
|
$r = mysql_fetch_object($results);
} ?>
} ?>
} else { ?>
Our first release is instore
12th Feb.
} ?>
|
|