[SOLVED] date field not updating

[jim.davidson]

I'm using dreamweaver8, php and mySQL 4.1.21

 

update_date is a hidden field in my form:

 

        <input name="update_date" type="hidden" id="update_date" value="now()" />

 

 

My received_date field is not being updated, any ideas why?   

 

if ($_POST['received'] = 'y') {

      $updateSQL = sprintf("UPDATE orders SET received_by=%s, received=%s, received_date=%s WHERE order_id=%s",

          GetSQLValueString($currentUser, "int"),

                      GetSQLValueString($_POST['received'], "text"),

                      GetSQLValueString($_POST['update_date'], "date"),

                      GetSQLValueString($_POST['order_id'], "int"));

      mysql_select_db($database_imcrecycle, $imcrecycle);

      $Result1 = mysql_query($updateSQL, $imcrecycle) or die(mysql_error());

    }

 

[fenway]

Echo $updateSQL and post it here.

[bubblegum.anarchy]

now() should not be quoted, assuming that the GetSQLValueString() function returns a quoted string.

[jim.davidson]

I worked around the problem by not using dreamweaver's GetSQLValueString() function