[PHP-DB] How do I get a ' in my sql statement?

I have noticed that when I try to assign the value of a input field that has a ' in it for example : can't It will goof up my attempt to load the information to the database. Anyone know a way around this? Do I have to send each string through a parsing routine before assigning my string to

Re: [PHP-DB] How do I get a ' in my sql statement?

Hello!! Spit some code out...I put a lot of ' in my inserts... Is it from a form?!?!!? Is it from a Insert, or Select or Update?!? That's why we need some code... Dan On Monday, June 10, 2002, at 12:01 PM, [EMAIL PROTECTED] wrote: I have noticed that when I try to assign the value of a

Re: [PHP-DB] How do I get a ' in my sql statement?

Any text field that has the possibility of getting quotes should be handled by $textfield = addslashes($textfield); prior to insert. Then on displaying, use $textfield = stripslashes($textfield); If it is a big text (including paragraphs) I use $textfield =

Re: [PHP-DB] How do I get a ' in my sql statement?

Terry, Thanks for the tip on the nl2br function. That function proved to be very helpful when displaying data in a HTML table. I noticed the \n is ok when sending text to a form with multiline input boxes. Thanks, Blaine Terry Romine [EMAIL PROTECTED] 06/10/02 02:35PM Any text field that