RE: [PHP-WIN] inserting quotes into a database...

Hi, Thanks for the responses. I'd tried inserting '' instead of ' but I was then addSlashes() afterwards which meant that it didn't work because this had become \'\' before it met the query... It all works fine now, and I have enabled magic_quotes_sybase so I don't have to add any string processing at all... Thanks for all the help, Kelvin. -----Original Message----- From: Dena Marchant [mailto:dena@aha.com] Sent: 03 May 2001 16:32 To: kelvin@sasdesign.co.uk Subject: RE: [PHP-WIN] inserting quotes into a database... Kelvin, try replacing all of the ' with '' -----Original Message----- From: Tom Mathews [mailto:tom.mathews@st.com] Sent: 03 May 2001 16:38 To: kelvin@sasdesign.co.uk Subject: Re: [PHP-WIN] inserting quotes into a database... In Oracle, you just doubl eup the characters. By this I mean change any occurances of ' to '' (use a string function!) before you try to insert the data. Tom