Text to mysql via php.

[rmurdo]

Hi all,

I have a new problem since I upgraded servers, I suspect my code was just wrong in the first place.

I have a form that gets a bunch of text in a textbox.

I pass it to a php file that basicly just does an insert.

What is happening is that the form data now contains punctuation like ticks, parens etc. If I use no pucntuation it updates, if I do use it, it does not. No errors.

What I suspect is that its seeing a ' or ) in the text and thinking its part of the sql statment.

What do you do to get around this?

Thanks,

Rob

[Piranha]

Without seing your code it is impossible to know what is the cause. But a guess would be that you don't use [man]mysql_real_escape_string[/man].