inserting ´ in a db
| From: | Yamil Ortega | Date: | Thu, 04 Oct 2007 02:44:34 +0000 |
| Subject: | inserting ´ in a db | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-262725@lists.php.net to get a copy of this message | ||
Hi list, good day.
I have a simple script that inserts text on a mysql table, that has a field
named description and the type is text.
Everting works fine, except when I try to insert a text that includes a
simple quote.
For example
Yamil´s car
I send the character string to a variable and then insert into a query. But
the mysql says that something is wrong with the query because the quote
after the l looks like the end of the string, and s car doesn`t look like
a valid part of the query.
Can anyone help me out, how to handle this error?
Thanks
Yamil