Re: Apostrophe's in PHP and SQL

[Anon]

Hello,

I enabled magic quotes so that i won't get sql errors when I have form responses with "My Best Work" or Dylan's Jokes.

However, when I add something like Dylan's, my output puts an extra ' or apostrophe. Everything else is working correctly just not the display of apostrophe's.

output: Dylan''s

How can I change this? I am using PHP to display my sql results on my web pages...

Thanks for your help!

[kparker]

You shouldn't have to do anything: magic quotes puts the correct escape sequences in when receiving data via POST or GET, so that when you add it to the database you don't have to do anything special.

But when you retrieve the data, there should be only a single ' character there, and writing this to html for display should just result in a single ' also. So I'm confused about why this is happening. Are you perhaps passing the retrieved data from one script to the next via hidden variables before displaying it?