php time function

Question

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

("INSERT INTO " . PREFIX . "messages (from, to, title, message, date) 
VALUES (" . $from . ", " . $to . ", " . $subject . ", " . $message . ", NOW())");

I hope you have escaped those variables using mysql_real_escape_string or something like that before passing it to the query. — anshul
– anshul, Commented Feb 25, 2010 at 15:55
Please provide the error message. Error messages are there for a reason. ;) — Teekin
– Teekin, Commented Feb 25, 2010 at 16:04

Scott Vander Molen · Accepted Answer · 2010-02-25 16:09:59Z

3

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

edited Feb 25, 2010 at 16:09

answered Feb 25, 2010 at 15:45

Scott Vander Molen

6,4296 gold badges44 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

OMG Ponies Over a year ago

GETDATE() is SQL Server specific - this question is for MySQL. CURRENT_TIMESTAMP is ANSI standard however, supported on both.

Adam Kiss Over a year ago

@Scott: dev.mysql.com/doc/refman/5.1/en/… ?

Scott Vander Molen Over a year ago

Woops, I've been trapped in the SQL Server world for too long.

David Radcliffe Over a year ago

FYI: the original question did not specify SQL or MySQL

ant · Accepted Answer · 2010-02-25 15:47:15Z

-2

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

answered Feb 25, 2010 at 15:47

ant

22.9k36 gold badges139 silver badges185 bronze badges

Collectives™ on Stack Overflow

php time function

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related