Message -
From: "Bryant Hester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:48 AM
Subject: RE: apostrophe and comma error on submit
You need to delimit them:
INSERT INTO table VALUES ('value
You need to delimit them:
INSERT INTO table VALUES ('value','Don\'t know','');
If you're inserting via PHP, you need to add a backslash before
apostrophes or commas in the post data, as apostrophes and commas are
used by MySQL to delimit fields on INSERT statements.
It's also in the manual,
escape your data with a black slash
\' if you mean to have a literal single quotation mark.
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about an