debugging problems
| From: | Taline Makssabo | Date: | Fri, 18 May 2001 13:44:02 +0000 |
| Subject: | debugging problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-53408@lists.php.net to get a copy of this message | ||
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("taline@prepresshelp.com", "You had a new visitor",$text, "FROM:
stat@prepresshelp.com.com");
}
}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) ;
}
?>