This is a program i wrote to get some information at keep track with some
stats. I am very new at this so bare with me....I keep on getting this
Warning:
Warning: Supplied argument is not a valid MySQL result resource in
/home/virtual/ppcu/home/httpd/html/php2/stat.php on line 13
Warning: Supplied argument is not a valid MySQL-Link resource in
/home/virtual/ppcu/home/httpd/html/php2/stat.php on line 17
Whats wrong???? Is it my code? Please help.
<?
global $dblink,$PHP_SELF;
$ip = getenv("REMOTE_ADDR");
$host = getenv("HTTP_HOST");
$browser = getenv("HTTP_USER_AGENT");
$referer = getenv("HTTP_REFERER");
$sql = "SELECT ipaddress FROM stat WHERE ipaddress = '$ip'";
$connection = @mysql_connect("localhost", "username", "password") or
die("Couldn't connect.");
$db_name = "contact";
$table_name = "stat";
$result = @mysql_query($sql, $dblink);
$num = mysql_num_rows($result);
if( $num == 0 )
{
$sql ="INSERT INTO stat(ipaddress,host,browser,referer,filename)
VALUES('$ip', '$host', '$browser', '$referer','$PHP_SELF')";
$result=mysql_query($sql,$dblink);
$sql1="INSERT INTO hits(ipaddress,count) VALUES('$ip',1)";
$result1=@mysql_query($sql1,$dblink);
$text="you had a new visitor from IP: $ip, Host: $host Browser:
$browser Referer: $referer";
if ($result)
{
mail("[EMAIL PROTECTED]", "You had a new visitor",$text, "FROM:
[EMAIL PROTECTED]");
}
}else{
$sql = "UPDATE hits SET count = count + 1 where ipaddress='$ip'";
$result =@mysql_query($sql, $dblink) ;
$sql2 = "UPDATE stat SET filename ='$PHP_SELF' where ipaddress='$ip'";
$result2 =@mysql_query($sql2, $dblink) ;
}
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
