PHP sql inserting data help?

M

moofin_poofin

New member
I have some php that adds data to an sql database, it was working fine before bu now it gets an error when trying to add data to the sql database.

mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$query = "INSERT INTO `stalk` (
`id` ,
`ip` ,
`date` ,
`time` ,
`browser` ,
`lang`
)
VALUES (
'$ip', '$date', '$time', '$browser', '$lang'
)";
mysql_query($query) or die("\nError inserting data");

It says error inserting data no matter what I do.... HELP?!!?
variable values:
$ip = $_SERVER['REMOTE_ADDR'];
$date = date('m/d/y');
$time = date('H:i:s');
$browser = $_SERVER['HTTP_USER_AGENT'];
$lang = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
i changed it to that,
($query = "INSERT INTO `stalk` ( `ip` , `date` , `time` ,`browser` , `lang` )
VALUES ( '$ip', '$date', '$time', '$browser', '$lang' )";)
but i still get the same problem.
 
you specified inserting 6 fields but you are providing 5 values.
Assuming that ID is autosequence change your sql to:
$query = "INSERT INTO `stalk` ( `ip` , `date` , `time` ,`browser` , `lang` )
VALUES ( '$ip', '$date', '$time', '$browser', '$lang' )";
 
Back
Top