#PHP RSS 2.0 Feed Maker v1.0
#This document is a sample rss feed maker for homemade blogs.
#It uses PHP to create an up-to-date RSS 2.0 feed from your MySQL database.
#
#Notes: I have created "comments" using the pound (#) symbol
#However, these aren't legal comments and will break your code
#You will have to remove all of the text on a line following a #, as well as the # itself
#Also, be sure to rename this file to a .php extension
#This document assumes the user is comfortable with PHP, MySQL, and general WebDevelopment
#
#Author: Eric Gustavson. Use & Modify all you want.
#I got started here: http://www.pageaffairs.com/web/rss/create-your-own-rss-feed/ and then coded the php myself
#Thanks to Ralph Mason, and the folks over at Page Affairs
#for helping me get started & providing the original rss xml document.

<?php
echo'<?xml version="1.0" encoding="UTF-8"?>'."\n";
?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
>

<channel>
	<title>Your Blog Title</title>
	<link>http://YourBlogUrl.com/</link>
	<atom:link href="http://YourBlogURL/rss2.php" rel="self" type="application/rss+xml" />
	<description>Your Feed Tagline</description>
	<language>en</language>
	
	<?php 
		//dynamic content
		$con = mysql_connect("localhost","DatabaseUser","DatabasePassword");
		if (!$con)
			die('Could not connect: ' . mysql_error());
		mysql_select_db("Database", $con);
		
		$result = mysql_query("SELECT * FROM posts ORDER BY id DESC") or die(mysql_error());  #replace 'posts' and 'id' with the appropriate fields from your DB
		while($row = mysql_fetch_array($result)) {
			echo '
			<item>
				<title>'.$row['title'].'</title>
				<guid isPermaLink="true">http://www.YourBlogUrl.com/?p='.$row['id'].'/</guid>  #Modify this expression to match your permalink scheme
				<link>http://www.ericmgustavson.com/?p='.$row['id'].'/</link> #Modify this expression to match your permalink scheme
				<description>'.str_replace("&","and",trim(substr(strip_tags($row['content']),0,225))).'...</description>
				#The above line shortens your post to 225 characters, strips away any HTML/PHP tags, trims off white space, and replaces & with "and" ('&' causes problems with feedburner)
			</item>';
		}
	?>
</channel>
</rss>