Duplicate entry '0' for key 1

[jasraj]

hey, i'm trying to gather reports for my website, but i keep getting the following error, not sure why.

 

Duplicate entry '0' for key 1

 

<?php

// find browser
if ( strpos($_SERVER['HTTP_USER_AGENT'], 'Gecko') )
{
   if ( strpos($_SERVER['HTTP_USER_AGENT'], 'Netscape') )
   {
     $browser = 'Netscape (Gecko/Netscape)';
   }
   else if ( strpos($_SERVER['HTTP_USER_AGENT'], 'Firefox') )
   {
     $browser = 'Mozilla Firefox (Gecko/Firefox)';
   }
   else if ( strpos($_SERVER['HTTP_USER_AGENT'], 'Chrome') )
   {
     $browser = 'Google Chrome (Gecko/Chrome)';
   }
else
   {
     $browser = 'Mozilla (Gecko/Mozilla)';
   }
}
else if ( strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') )
{
   if ( strpos($_SERVER['HTTP_USER_AGENT'], 'Opera') )
   {
     $browser = 'Opera (MSIE/Opera/Compatible)';
   }
   else
   {
     $browser = 'Internet Explorer (MSIE/Compatible)';
   }
}
else
{
   $browser = 'Others browsers';
}

// find IP
$intpro = $_SERVER[REMOTE_ADDR];

// get page name
$page = str_replace("/~gj719/gigbookers/", "", $_SERVER[php_SELF]);

// get user ID
$loginid = $_SESSION['userid'];

$string = "INSERT INTO logreport (log_id, gblogin_id, page, browser, datetime, ipaddress) VALUES ('', '$loginid', '$gblogin_id', '$browser', NOW(), '$ipad')";

$result = mysql_query( $string ) or die ( mysql_error() );

?>

 

 

[wildteen88]

Im guessing log_id is an auto_increment key? If its don't include it in your query.

$string = "INSERT INTO logreport (gblogin_id, page, browser, datetime, ipaddress) VALUES ('$loginid', '$gblogin_id', '$browser', NOW(), '$ipad')";