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, somewhere....
HTH,
Bryant Hester
Mysql, query
-----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 error that occurs when you try to submit into
mysql.
Whever i try to imput any text with a comma in it or an appostrophe, i
get an error until i remove it.
Any suggestions. .. anyone...? Im using php and submiting via post,
when i get the error. Thank you so much for your time. Leeann
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
