RSS Feed

<?php

// Establishes db connection
$database = "database";
$username = "username";
$password = "password";
mysql_connect("localhost", $username, $password) || die ("Unable to select database");
mysql_select_db($database);

//Path and name to save xml file 
$output = "feeds/feed.xml";

//Opens output file for writing
$open = fopen($output, "w+");

//Writes standard tags output file
fwrite($open, "<?xml version=\"1.0\" ?>\n");
fwrite($open, "<rss version=\"2.0\">\n");
fwrite($open, "<channel>\n");
fwrite($open, "<title>Enter site title here</title>\n");
fwrite($open, "<description>Enter description of your site there</description>\n");
fwrite($open, "<link>http://www.yoursite.com</link>\n");

// Grabs last 10 records
$query = "SELECT * FROM tablename ORDER BY id DESC LIMIT 10";
$result = mysql_query($query);
$num = mysql_num_rows($result); 
$i = 0;

while ($i < $num) {

 $title = mysql_result($result,$i,"title");
 $desc = mysql_result($result,$i,"description");
 $link = mysql_result($result,$i,"link");

 fwrite($open, "<item>\n");
 fwrite($open, "<title>" . $title . "</title>\n");
 fwrite($open, "<description>" . $desc . "</description>\n");
 fwrite($open, "<link>" . $link . "</link>\n");
 fwrite($open, "</item>\n");

$i++;
}

// Writes standard closing tags
fwrite($open, "</channel>\n");
fwrite($open, "</rss>");

//Closes output file
$close = fclose($open);

echo "RSS feed generated!";

?>