[PHP] on the list yesterday regarding mysql time

2001-03-07 Thread Jerry Lake
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 -00-00

RE: [PHP] on the list yesterday regarding mysql time

2001-03-07 Thread John Huggins
inal 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

RE: [PHP] on the list yesterday regarding mysql time

2001-03-07 Thread Jerry Lake
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 .= "datesubm