quotes in mysql
| From: | Sudeep Sarath | Date: | Fri, 02 Apr 2004 08:16:26 +0000 |
| Subject: | quotes in mysql | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-23346@lists.php.net to get a copy of this message | ||
Hi friends,
I have a 'textarea' in my php page and i need to put the details typed in that textarea
box to my MySQL database. The content in the textarea box is(for example) : I'm a good boy.
and insert string is:
insert into table_name (describe) values('" . $check . "')
where check is the variable that stores the POST data of textarea. Also the field
"describe" is of a text datatype.
what happens is that i can't take the content string to the database. B'cause it contains
I'm (a single quote in between I and m) which confuses mySql that string terminates after I. Is
there any solution for this problem as we cannot tell the users "dont put quotes in
textarea".
....SuDeEp...
Win an evening with the Indian cricket captain: Yahoo! India Promos.