[PHP] adding the date to a database

[Brad Wright]

Hi, 
I have a database with a 'date' field. What is the syntax for using the
(mysql) function 'getdate()', to insert the date into the DB table.
the syntax I'm currently using is:
$query = "Insert INTO visits (visName, date)
            values ('$name', getdate()) " ;
$result = mysql_query($query, $db);

This does not work (but returns no errors) ie, nothing inserted into the
database.

Thanks,
Brad


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]