There are no stupid questions??

How do I pass the CURDATE() mySQL function in a PHP query???

Obviously, I'm missing something real simple here.

Trying to use PHP to pass "NOW" as the date in a date field. "quest_date" is the not null date field(below).

I just want the current date inserted where I have "NULL" below.


This Insert isn't working:

$query = "INSERT INTO questions (quest_name, quest_email, cat_id, quest_show, quest_text, quest_ip, quest_date) VALUES ('$quest_name', '$quest_email','$cat_id', 't', '$quest_text', '$orig_ip', NULL)";


Is there a way to add the CURDATE() mySQL function to where the "NULL" is above?

Forgive my ignorance.

Thanks in advance.

$query = "INSERT INTO questions VALUES ('$quest_name', '$quest_email','$cat_id', 't', '$quest_text', '$orig_ip', 'CURDATE())";

I really screwed up the answer, this is it I hope :-)

$query = "INSERT INTO questions VALUES ('$quest_name', '$quest_email','$cat_id', 't', '$quest_text', '$orig_ip', 'CURDATE()')";

I'm really exhausted I think. Just type CURDATE() not 'CURDATE()'.

There's no stupid question but dumb answers. One should always avoid sleep depreva tion.

Worked perfect - thanks a million