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

2001-03-07 Thread Jerry Lake
: 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', "; $que

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

2001-03-07 Thread John Huggins
mmand. > -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 so

[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 format?