Re: Special characters --> single quote

Hi David, Thank you for you response. In fact, th solution was found by Jason with the function str_replace. :-) $query = "UPDATE toto SET OBSERVATION = '".str_replace("'", "''", $OBSERVATION)."' WHERE id = $number"; Regards, Ludovic David Robley a écrit : > On 22 Aug, ludovic wrote: > > This is the query > > > > $query = > > "update toto set > > OBSERVATION='$OBSERVATION' where id =$number"; > > > > and the data field OBSERVATION is declared in my Sybase Database in a long varchar. > > > > The configuration of my php3.ini is > > ;;;;;;;;;;;;;;;;; > > ; Data Handling ; > > ;;;;;;;;;;;;;;;;; > > magic_quotes_gpc = Off ; magic quotes for incoming GET/POST/Cookie data > > > > Regards, > > > > Ludovic > > > > For sybase, there is a special magic quotes setting - > magic_quotes_sybase which according to the docs "If magic_quotes_sybase > is also on, a single quote is escaped with a single quote instead of a > backslash if magic_quotes_gpc or magic_quotes_runtime is enabled" > > Perhaps this may solve your problem. > > Cheers > -- > David Robley | WEBMASTER & Mail List Admin > RESEARCH CENTRE FOR INJURY STUDIES | > http://www.nisu.flinders.edu.au/ > AusEinet | > http://auseinet.flinders.edu.au/ > Flinders University, ADELAIDE, SOUTH AUSTRALIA