Dealing with '

[Modrick]

Sorry is this question has been ask a bunch of times, but I'm new here.

When doing a insert into mySQL via PHP with 's I'm having an issues, for example "John's pizza" will get inserted as "John/s pizza" I know it doing this because data gets insert like 'xxxxxx' and if you have a 'xxxxxxx'xxxxxx' I can see how it gets messed up....

At anyrate is there a work around, a link anyone can point me to? ty.

[jeremuck]

sure, lookup addslashes and magicquotes in the manual.

While you're at it, check out encode/decode functions. They will help you manager your strings.