Hi guys, i found a script on the net which creates a xml file from a mysql driven php file. I wish to modify this script so that it creates a valid RSS feed. I'm having a bit of difficulty. This is my code:
<?php
$db_name = "*********";
$link = mysql_connect("*********", "*********", "*********") or die("Could not connect to server!");
$table_name = 'mynews';
$select_db = mysql_select_db($db_name, $link);
$query = "SELECT * FROM mynews " . $table_name;
$result = mysql_query($query, $link) or die("Could not complete database query");Send a MySQL query
$num = mysql_num_rows($result);
if ($num != 2) {
$file= fopen("rss.xml" , "w");
$_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";
$_xml ="<rss version='2.0'>\r\n";
$_xml .="<channel>\r\n";
while ($row = mysql_fetch_array($result)) {
$_xml .=" <item>\r\n";
$_xml .=" <title>" . $row[ title] . "</title>\r\n";
$_xml .=" <content>" . $row[ content] . "</content>\r\n";
$_xml .=" <message>" . $row[ message] . "</message>\r\n";
if ($row[website]) {
$_xml .=" <user>" . $row[ user] . "</user>\r\n";
} else {
}
$_xml .=" </item>\r\n";
}
$_xml .="</channel>";
fwrite($file, $_xml);
fclose($file);
echo "<a href=rss.xml>RSS FEED</a>";
} else {
echo "No Records found";
}
?>
With the above code i get an error in my XML page which reads
I'm pretty sure i have a problem with this line too:
$_xml ="<rss version='2.0'>\r\n";
Doubt that is valid tbh.
