[SOLVED] INSERT INTO, HELP!

[brophi]

Server version: 5.0.45-community-nt

 

The brocken code:

$to = mysql_real_escape_string($_POST['to']);
$text = mysql_real_escape_string($_POST['text']);
$from = mysql_real_escape_string($_SESSION["sessioname"]);
mysql_query("INSERT INTO mail (to, from, text, datetime) VALUES ('$to', '$from', '$text', NULL)")

 

The mysql_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 'to, from, text, datetime VALUES ('Brophi', 'Brophi', 'Test', NULL)' at line 1

 

The 'mail' table:

CREATE TABLE `mail` (\n  `to` text collate latin1_general_ci NOT NULL,\n  `from` text collate latin1_general_ci NOT NULL,\n  `text` text collate latin1_general_ci NOT NULL,\n  `datetime` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

 

Can someone please help, I keep getting this error, although i havnt ttried much cause i dont know much about mysql syntax, im sorry if this post is hard to read, but please help

[~n[EO]n~]

INSERT INTO mail (
`to` ,
`from` ,
`text` ,
`datetime`
)
VALUES (
'$to', '$from', '$text', NOW( )
);

 

You can use NULL, in place of NOW()

[brophi]

thanks