Thanks, that worked great.
Jerry Lake - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online - http://www.pacifier.com
-----Original Message-----
From: John Huggins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 2:49 PM
To: Jerry Lake; [EMAIL PROTECTED]
Subject: RE: [PHP] on the list yesterday regarding mysql time
Forget about the PHP functions and do this:
$query = "INSERT INTO tablename ";
$query .= "SET field1 = '$field1', ";
$query .= "field2 = '$field2', ";
$query .= "datesubmitted = NOW();
Let MySQL simply do this for you with the NOW() SQL command.
> -----Original Message-----
> From: Jerry Lake [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 5:41 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] on the list yesterday regarding mysql time
>
>
> I know this was on the list yesterday,
> but I for some reason erased it.
>
> I have an online form that I would like
> to have record the time submitted and
> recorded into a MySQL date field, how
> the hell do I use the date and mktime
> functions to make the date compatible
> with the MySQL 0000-00-00 format?
>
> Jerry Lake - [EMAIL PROTECTED]
> Web Designer
> Europa Communications - http://www.europa.com
> Pacifier Online - http://www.pacifier.com
--
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]
