Miscellany

<?php
// connect to database else print error

$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
 
// select the database

$db = 'filter';
mysql_select_db($db)
 
or die( "Error! Could not select the database: " . mysql_error() );
 

 $xml = simplexml_load_file('http://www.sportsnet.ca/rss/homepage.xml');
 foreach ($xml->channel[0]->item as $item) {
        if($item) {
            $title = strip_tags($item->title);
            $description = strip_tags($item->description); 

}
}

$qry=mysql_query("SELECT data FROM CiscoData");


$row = mysql_fetch_row($qry);
     if( $row[0] !== $title)
	 
	
	
	$qry1 = mysql_query("INSERT INTO CiscoData (type,data);
VALUES ('Games' , '" . mysql_real_escape_string($title) . "')");

mysql_close($cid);
 
?>