problem with date() tag

[floppi]

I have written a script and I think it works. But now I have added a date() funktion and now I get always an error.

part of my script:

$link = mysql_connect ($host, $user, $password);
$datum = date("Y-m-d H:i:s", time());
$query = "insert into $tablename values ("", "$name", "$email", '"addy", "$datum", "$comments")";
$result = mysql_db_query ($dbname, $query, $link);
while ($row = mysql_fetch_array($result)) { ....

and this is my error message:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in c:\hp\cdscribere.php on line 22

PS: Line 22 starts with $query ...

I hope somebody can help me
thx Floppi

[dannys]

$query = "insert into $tablename values ("", "$name", "$email", '"addy", "$datum", "$comments")"; 

Should be

$query = "insert into $tablename values ('', '$name', '$email', 'addy', '$datum', '$comments')"; 

[el_kab0ng]

Actually, if you're skipping the first entry because it's an autoincremented ID or something use the word NULL.

$query = "insert into $tablename values (NULL, '$name', '$email', 'addy', '$datum', '$comments')";

notice, no ticks.