update

<?php

//parseFeed('http://www.bsava.com/DesktopModules/DNNGo_xNews/Resource_Ajax.aspx?ModuleId=2176&ajaxType=2&TabId=315', 'bsava');
parseFeed('http://www.bva.co.uk/custom/pages/news/newsrelease/feed.aspx', 'bva');


//read the content of the XML document


function parseFeed($feed_url, $database)
{


    $db_hostname = "localhost";
    $db_username = "";
    $db_password = "";
    $db_database = "";
    $db_table = $database;
    $db = mysql_connect($db_hostname, $db_username, $db_password);


    if (!$db) {
        die("Could not connect: " . mysql_error());
    }
    mysql_select_db($db_database, $db);
    libxml_use_internal_errors(true);
    $RSS_DOC = simpleXML_load_file($feed_url);

    if (!$RSS_DOC) {


        echo "Failed loading XML\n";


        foreach (libxml_get_errors() as $error) {


            echo "\t", $error->message;


        }


        $rss_title = $RSS_DOC->channel->item->title;
        $rss_link = $RSS_DOC->channel->item->link;
        $rss_description = $RSS_DOC->channel->item->description;
        $rss_date = $RSS_DOC->channel->item->pubDate;


    }

    $feeds = mysql_query("SELECT item_id FROM database");
    $rows = mysql_fetch_array($feeds, MYSQL_NUM);

    $feedarray = array();
    if($rows) foreach($rows as $row) $feedarray[] = $row->item_id;


    foreach ($RSS_DOC->channel->item as $RSSitem) {

        if(in_array(md5($RSSitem->title), $feedarray)) {

            echo "<font color=blue>Not inserting existing item..</font><br/>";

        } else {

            $item_id = md5($RSSitem->title);
            $fetch_date = date("Y-m-j G:i:s"); //NOTE: we don't use a DB SQL function so its database independant
            $item_title = $RSSitem->title;
            $item_date = date("Y-m-j G:i:s", strtotime($RSSitem->pubDate));
            $item_url = $RSSitem->link;
            $item_content = $RSSitem->description;
            echo "Processing item '", $item_title, "' on ", $item_date, "<br/>";
            echo "<font color=green>Inserting new item..</font><br/>";
            $item_insert_sql = "INSERT INTO $db_table(item_id, feed_url, item_title, item_date, item_url, fetch_date, item_content) VALUES ('$item_id', '$feed_url', '$item_title', '$item_date', '$item_url', '$fetch_date', '$item_content')";
            $insert_item = mysql_query($item_insert_sql, $db);
            echo $item_id, "<br>";

        }


    }


}



?>