<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><?php header('Content-type: text/xml'); ?><rss xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">
<channel>
<title>Essential Oil Testimonials</title>
<description>Essential oils contain healing properties.  Come read how others use the oils on a daily basis.  Share what you know.  Learn what you don't.</description>
<link>http://www.oil-testimonials.com/</link>
<copyright>Copyright 2006</copyright>


<?php include 'db.inc.php'; 


$getTestimonials = "SELECT u.uID, u.firstname, u.lastname, t.tID, t.date, t.summary from users u, testimonies t where u.uID = t.author and t.approved ='Yes' order by t.date desc limit 15";

$result = mysql_query ($getTestimonials) OR die(mysql_error());

if ($row = mysql_fetch_array($result)) {

do {
$uID		= $row["uID"];
$firstname	= $row["firstname"];
$lastname	= $row["lastname"];
$tID		= $row["tID"];
$date		= $row["date"];	
$summary	= $row["summary"];
$testimony	= $row["testimony"];

$date = date("D, d M Y H:i:s \G\M\T");

$summary	= str_replace("&", "&amp;", $summary); 
$testimony	= str_replace("&", "&amp;", $testimony); 

$summary	= stripslashes($summary);
$testimony	= stripslashes($testimony);

htmlentities(strip_tags($summary));
htmlentities(strip_tags($testimony,'ENT_QUOTES'));

//$testimony	= ereg_replace(10,"<p>",$testimony);
//$testimony	= ereg_replace(34,"'",$testimony);


print ("\n\n<item>\n");
print ("<title>$summary</title>\n");
print ("<description>Testimonial submitted by $firstname $lastname.</description>\n");
print ("<guid isPermaLink=\"true\">http://www.oil-testimonials.com/essential-oils/$tID</guid>\n");
print ("<link>http://www.oil-testimonials.com/essential-oils/$tID</link>\n");
print ("<pubDate>$date</pubDate>\n");
print ("</item>"); 



} while($row = mysql_fetch_array($result));

} else {print "Sorry, no testimonials were found!";}



?> 


<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/EssentialOilTestimonials" /><feedburner:info uri="essentialoiltestimonials" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /></channel>
</rss>

