you could try the replace function of mySQL
lewell
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
----- Original 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','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
---------------------------------------------------------------------
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
