php time function

what is wrong with this sql query? he is crying on NOW() :(

("INSERT INTO " . PREFIX . "mess开发者_开发技巧ages (from, to, title, message, date) 
VALUES (" . $from . ", " . $to . ", " . $subject . ", " . $message . ", NOW())");

---

Are you using MySQL or Microsoft SQL Server? NOW() doesn't work in SQL Server; need to use GETDATE() instead.

---

Maybe using current time stamp would be better idea, I don't know it, just type timestamp in mysql you'll find it on google