Thanks a lot frank, It's working nicely :o) "Frank M. Kromann" <frank@kromann.info> wrote in message 10546986350400000@9866357972520000.9866341568840000">news:10546986350400000@9866357972520000.9866341568840000... > > That depends on your backend. Some database systems uses \ to escape ' > others uses '. In the last case use > > $value = str_replace("'", "''", $value); > > - Frank > > > Don't. addslashes() instead. > > > > Chris Mach wrote: > > > > >does anyone know how to strip a ' from a string? It's causing errors > for my > > >sql statements > > > > > > > > > > > > > > > > > > > -- > > The above message is encrypted with double rot13 encoding. Any > unauthorized attempt to decrypt it will be prosecuted to the full extent > of the law. > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php