There are any number of elements to try htmlspecialchars mysql_real_escape_string addslashes RTFM and see what works best for your situation bastien> From: jiuman@xxxxxxxxx> To: php-general@xxxxxxxxxxxxx> Date: Thu, 4 Oct 2007 11:44:34 +0900> Subject: inserting ´ in a db> > 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> _________________________________________________________________ Show your pals how you really feel! Learn more today! http://www.freemessengeremoticons.ca/
