Re: Line Breaks Problem (\r\n) in Query

2005-04-05 Thread Brent Baisley
I'm not sure what may have changed, but what you are searching on is really a partial value of a field. You wouldn't normally think of \r\n as characters, but they are are, just like a or b. Whenever you are searching on a partial value, you should use LIKE and %. SELECT * FROM table_name WH

Re: line breaks

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
Tarik, > - what is the stored character code of the enter key in the text field, i am > figuring out to find that character and replace it with the element, > for the exact display, The character is "\n" (the new line character). If you use PHP and have magic_quotes=on in your php.ini, PHP will

Re: line breaks

2003-02-01 Thread Benjamin Pflugmann
Hi. In which way is this a MySQL related problem? Please choose a more appropriate forum next time. On Fri 2003-01-31 at 18:22:50 +0200, [EMAIL PROTECTED] wrote: > Hi, > > >From a web form I am collecting information to a table. On the form there is > a textarea element storing to a text field o

Re: line breaks

2003-02-01 Thread Zak Greant
On Fri, Jan 31, 2003 at 06:22:50PM +0200, Tarik Kutluca wrote: > Hi, > > >From a web form I am collecting information to a table. On the form there is > a textarea element storing to a text field on the mysql table. Since the > textarea can hold the enter key, it's stored in to the field also, but