Re: inserting ´ in a db

From: 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


« previous php.general (#262736) next »