(.*?)<\/title>/',$content,$thetitle); preg_match_all('/(.*?)<\/content>/is',$content,$thedesc); $newtitle = $thetitle[1][1]; if($newtitle!=""){ $desc = $thedesc[0][0]; $desc = str_replace("<", "<", $desc); $desc = str_replace(">", ">", $desc); $desc = str_replace("byline-author", "posted", $desc); unset($content); $db = connect_to_sql(); connect_to_dbase($db); $sql="select * from tablename where site='Official Google Blog'"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_object($result); if ($row->title != $newtitle) { print "Stored title was: ".$row->title." The new title is: ".$newtitle."

"; $newtitle = addslashes($newtitle); $db = connect_to_sql(); connect_to_dbase($db); $sql2 = "update tablename set title='$newtitle', cstamp=now() where site='Official Google Blog'"; $result2 = mysql_query($sql2) or die(mysql_error()); $desc=strip_tags($desc,'
'); $newtitle = stripslashes($newtitle); $to = 'emailaddress@gmail.com'; $subject = 'Google Blog RSS Update: '.$newtitle; $message = 'Official Google Blog Update (http://googleblog.blogspot.com)

Title : ' . $newtitle .'

Message: ' . $desc.''; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'From: emailaddress@gmail.com'; if(mail($to, $subject, $message, $headers)) print "Emailed Official Google RSS change."; } else print "No Official Google RSS Update."; } ?>