CREATE TABLE googlebot ( id int(25) unsigned NOT NULL auto_increment, date datetime NOT NULL default '0000-00-00 00:00:00', uri varchar(255) NOT NULL default '', agent varchar(255) NOT NULL default '', ip varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; $mysql_host = "localhost"; $mysql_user = "mmaaaco_ksecor"; $mysql_passwd = "hamilton"; $mysql_dbname = "mmaaaco_mydb"; $db = @mysql_connect($mysql_host,$mysql_user,$mysql_passwd); if (!$db) die("error!"); $agent = $_SERVER['HTTP_USER_AGENT']; $guri = $_SERVER['REQUEST_URI']; $ip = $_SERVER['REMOTE_ADDR']; if(@ereg("Google", $agent)){ @mysql_query("INSERT INTO googlebot (date, uri, agent, ip) VALUES (now(),'$guri', '$agent', '$ip')", $db); } ?>