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

2002-06-10 Thread Blaine Dinsmore
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 fiel

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

2002-06-10 Thread Terry Romine
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 = nl2br(stripsl

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

2002-06-10 Thread Daniel Brunner
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