<?php

header('Content-type: text/xml');

?>



<rss version="2.0">

<channel>

<title>The Title Of the RSS Feed.</title>

<description>Your description of the rss feed here.</description>

<link>YOURADDRESS/rss.php</link>

<link rel="alternate" type="application/xml" title="<?php echo "Title Of RSS Feed" href="http://www.newmedia.lincoln.ac.uk/jecgardner/rss.php" />?>



<?php



  mysql_connect ('localhost', 'xxxxxx', 'xxxxxx');

mysql_select_db ('hullweb_jgardner');



//build and issue query



$sql ="SELECT * FROM php_blog ORDER BY timestamp";

$result = @mysql_query($sql,$connection)or die(mysql_error());



//create list block of results

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

    $id = $row['id'];

    $title = $row['title'];

    $entry = $row['entry'];

        $entry=strip_tags($entry);

        $entry=ereg_replace(" "," ",$entry);

    $timestamp = $row['timestamp'];

        $timestamp = date("F j, Y");



?>



  <item mmTranslatedValueHiliteColor="HILITECOLOR=%22Dyn%20Untranslated%20Color%22">

  <title><? echo "$title"; ?></title>

  <description><? echo "$entry"; ?></description>

  <pubDate><? echo "$timestamp"; ?></pubDate>

  </item>



<?

  }

?>

</channel>

</rss>