Re: inserting ´ in a db
| From: | Aleksandar Vojnovic | Date: | Thu, 04 Oct 2007 05:28:09 +0000 |
| Subject: | Re: inserting ´ in a db | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-262736@lists.php.net to get a copy of this message | ||
Pick one:
http://si2.php.net/manual/en/function.htmlentities.php
http://si2.php.net/manual/en/function.addslashes.php
http://si.php.net/mysql_escape_string
Aleksandar
Yamil Ortega wrote:
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