1st create ONE table (not four) as follows:-

CREATE TABLE statinfo (
   browser text NOT NULL,
   date text NOT NULL,
   host text NOT NULL,
   referer text NOT NULL
);

Then in the php3 file use the following code to populate it.

<?
$dbname 'YOUR_DATABASE_NAME';
include('db.inc.php');

$browser = $HTTP_USER_AGENT;
$date = date("F jS Y, h:iA");

if ($REMOTE_HOST == "") {$host = $REMOTE_ADDR;}
else {$host = $REMOTE_HOST;}

if( empty( $HTTP_REFERER ) or '' == $HTTP_REFERER ) {$HTTP_REFERER = 'No Referer';}

$mysqli->query("INSERT INTO statinfo (browser, date, host, referer) VALUES ('$browser','$date','$host','$HTTP_REFERER' )");

$mysqli->close();
?>

Works great. Any problems, contact me via http://www.xploiter.com/form.shtml

Regards

Simon Steed