Q:

PHP- insert todays date into MySql field not working

Pretty simple to some people, but pretty new to PHP. I just want to insert today date into a date field in MySQL
Thanks in advance.
$sql = "UPDATE IA SET IASubmitted ='yes', IASubmittedDate='date('Y-m-d')' WHERE Reference='$Reference'";
$result=mysql_query($sql); 

A:

I think the simplest answer is as follows:
$sql = "UPDATE IA SET IASubmitted ='yes', IASubmittedDate='". date('Y-m-d'). "' WHERE Reference='$Reference'";
$result=mysql_query($sql); 

