PHP/Mysql error

[nbarone]

I'm hoping someone here will have a better eye at catching this error than I have.

 

Thanks in advance.

 

Actual code:

$sql = "INSERT INTO mfl_files (file_name, file_share, file_path, file_created, file_modified, file_lastVerified, file_active)
VALUES ('$file', '$shr_id', '$dir', '$dateCreated', '$dateModified', '$newDateVer', '1')";

 

$sql output:

INSERT INTO mfl_files (file_name, file_share, file_path, file_created, file_modified, file_lastVerified, file_active) 
VALUES ('09-6-2009-dvd.mov', '1', '\\fileserver01\SHARE01\VIDEO\DVD Files\2009\', '2009-11-24 09:33:11', '2010-02-03 16:37:34', '2010-02-25 10:37:28', '1')

 

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2009-11-24 09:33:11', '2010-02-03 16:37:34', '2010-02-25 10:37:28', '1')' at line 2

[developerdave]

What type of field are the 'file_created, file_modified, file_lastVerified' columns your trying to put datetime into?

 

 

[nbarone]

They are all datetime fields.

 

[shlumph]

You're escaping the single quotation.. try changing \\fileserver01\SHARE01\VIDEO\DVD Files\2009 to \\fileserver01\SHARE01\VIDEO\DVD Files\2009\\

[nbarone]

You're escaping the single quotation.. try changing \\fileserver01\SHARE01\VIDEO\DVD Files\2009 to \\fileserver01\SHARE01\VIDEO\DVD Files\2009\\

 

Thanks, that was the issue.