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
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