mysql error somewhere

[auriaks]

hi,
I use this script to insert my info onto mysql:

mysql_query("INSERT INTO inbox (To, msg, from, look, date, time, tema) 
        VALUES('$to', '$msg', '$from', '$look', '$date', '$time', '$tema')") or die(mysql_error()); 

My table rows are:

CREATE TABLE IF NOT EXISTS `inbox` (
  `id` int(50) NOT NULL,
  `To` varchar(40) character set utf8 collate utf8_lithuanian_ci NOT NULL,
  `msg` varchar(1000) character set utf8 collate utf8_lithuanian_ci NOT NULL,
  `from` varchar(30) character set utf8 collate utf8_lithuanian_ci NOT NULL,
  `look` varchar(30) character set utf8 collate utf8_lithuanian_ci NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `tema` varchar(200) character set utf8 collate utf8_lithuanian_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1; 

but i got 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, msg, from, look, date, time, tema) VALUES('mantelis', 'kitas', 'admin', '' at line 1 

Whats wrong??

[Schmoopy]

Try:

mysql_query("INSERT INTO inbox (`To`, `msg`, `from`, `look`, `date`, `time`, `tema`) 
        VALUES('$to', '$msg', '$from', '$look', '$date', '$time', '$tema')") or die(mysql_error()); 

This will make them read as columns and not as statements.
Since some columns can be confused, like DATE and FROM

[auriaks]

Thanks.... working