Hello,
i am having trouble with this php code it shows a blank page but it should output data in xml
[php]<?PHP
$link = mysql_connect(“localhost”,“dbuser”,“dbpass”);
mysql_select_db(“dbname”);
$query = "SELECT requestlist.host, requestlist.msg, requestlist.name, songlist.ID, songlist.count_requested, songlist.artist, songlist.title,
songlist.album, songlist.buycd, songlist.date_played, count(*) as cnt FROM requestlist, songlist
WHERE (requestlist.songID = songlist.ID) AND (requestlist.code<700) GROUP BY requestlist.msg, songlist.ID, songlist.count_requested,
songlist.artist, songlist.title, songlist.album, songlist.buycd, songlist.date_played ORDER BY requestlist.msg DESC, songlist.date_played DESC" ;
$results = mysql_query($query);
echo “\n”;
while($line = mysql_fetch_assoc($results)) {
echo " \n";
echo “” . $line[“artist”] . “\n”;
echo “” . $line[“title”] . “\n”;
echo “”. $line[“album”] ."\n";
echo “”. $line[“name”] ."\n";
echo “” . $line[“msg”] . “\n”;
echo “\n”;
}
echo “\n”;
mysql_close($link);
?>[/php]
thanks