Database not updating

[Jon12345]

I have the following code to add a record into my mysql database:

[code]<?php
$kid="abc";
$ipaddress="12342";
$sid="7Search";
$time = date("H:i:s");
$date = date("m.d.y");

$db=mysql_connect("localhost","user","pw");
mysql_select_db("pmm__log",$db);
$query="INSERT INTO visitor_log (ipaddress,date,time,kid,sid) VALUES ('$ipaddress','$date','$time','$kid','$sid')";
mysql_query($query) or die('Database Query Error: '.mysql_error());

mysql_close() 
?> [/code]

But it doesn't update. I cannot work out why. I get the following error message echoed to the browser:

Database Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ipaddress','date','time','kid','sid') VALUES ('12342','12.11.06

Any ideas what the problem might be? Permissions? Syntax?

Thanks,

Jon

[mattcairns]

This is just a guess but, try changing
$date = date("m.d.y");
to
$date = date("Y-m-d");

if the date field in your mysql database is looking for a date this is the format it would accept.

[Jon12345]

It still gives an error.

[Jon12345]

Found solution. I had two underscores here: pmm__log

[mattcairns]

ah, so easy to overlook.