|
|

mysql_connect("localhost", "red169859", "jkvm4za");
$query = "SELECT NewsDate, Subject, Artists.ArtistName AS Artist, News FROM News, Artists WHERE News.ArtistID = Artists.ArtistID ORDER BY NewsDate DESC";
$results = mysql_db_query("redlinerecords_com_au", $query);
//change localhost TO "localhost"
// change "redlinerecords_com_au" to "redlinerecords_com_au"
/* Using the below to test, it appears $results is blank!?
echo "\n";
echo "MY SQL Output: ";
echo $results;
echo "\n";
*/
$count = 0;
while ($count < 9) {
($r = mysql_fetch_object($results));
?>
list ($year, $month, $day, $hour, $minute) = split('[- :]',$r->NewsDate); echo "$day/$month/$year $hour:$minute"; ?>
(GMT) :::
echo $r->Subject; ?>
:::
echo $r->Artist; ?>
$news = ereg_replace("\n", " ", $r->News); echo $news; ?>
$count++;
}
?>
Distributed
in Australia and New Zealand by:
|
Heard on-line:
|
|
|