|
|

mysql_connect("localhost", "red169859", "jkvm4za");
?>
 |
Artists
|
//Our Artists' sites
$query = "SELECT ArtistName AS Name, Website AS URL FROM Artists WHERE Website != \"\" ORDER BY Name";
$results = mysql_db_query("redlinerecords_com_au", $query);
while ($r = mysql_fetch_object($results)) { ?>
echo $r->Name; ?>
} ?>
$query = "SELECT Name, URL FROM Links WHERE TypeID=1 ORDER BY Name";
$results = mysql_db_query("redlinerecords_com_au", $query);
while ($r = mysql_fetch_object($results)) { ?>
echo $r->Name; ?>
} ?>
|
 |
Labels
|
$query = "SELECT Name, URL FROM Links WHERE TypeID=2 ORDER BY Name";
$results = mysql_db_query("redlinerecords_com_au", $query);
while ($r = mysql_fetch_object($results)) { ?>
echo $r->Name; ?>
} ?>
|
 |
E-Zines
|
$query = "SELECT Name, URL FROM Links WHERE TypeID=3 ORDER BY Name";
$results = mysql_db_query("redlinerecords_com_au", $query);
while ($r = mysql_fetch_object($results)) { ?>
echo $r->Name; ?>
} ?>
|
 |
Miscellaneous
|
$query = "SELECT Name, URL FROM Links WHERE TypeID=4 ORDER BY Name";
$results = mysql_db_query("redlinerecords_com_au", $query);
while ($r = mysql_fetch_object($results)) { ?>
echo $r->Name; ?>
} ?>
|
|
|