Thanks, Jeremy and Bastien. I just tried nl2br and it has the unfortunate side effect of losing everything except the most recently added data when I update the database. I think I need something like the 'local $/ = "\r\n"' construct in perl... Giff _____ From: Jeremy Peterson [mailto:jeremy.peterson@xxxxxxxxx] Sent: Monday, March 20, 2006 5:14 PM To: Giff Hammar Subject: Re: Remove newlines from field Try nl2br. http://php.net/nl2br At 04:00 PM 3/20/2006, you wrote: I am using a PHP script to pull information from a FoxPro database via ODBC. One of the fields is a memo field (large text) that contains newline characters. Displaying this info to the web page is fine as the newlines are ignored. The challenge is when I combine user entered text with the existing info and try to update the database. It fails with an "unrecognized command" because the end of field delimiter is on a different line. We're running on PHP 4.2.7 and I have tried using various combinations of str_replace to eliminate the newline characters, but I have been unsuccessful. Any suggestions? Giff Giff Hammar IT Director Certified Parts Warehouse http://www.certifiedparts.com <http://www.certifiedparts.com/> < <http://www.certifiedparts.com/> http://www.certifiedparts.com/> mailto: ghammar@xxxxxxxxxxxxxxxxxx V: 603.516.1707 F: 603.516.1702 M: 603.490.7163 Jeremy Peterson, MACS Automation Systems Administrator Crowell Library Moody Bible Institute 820 N. LaSalle Drive Chicago, IL, 60610 Email: jpeterso@xxxxxxxxx Phone: 312.329.8081 Fax: 312.329.8959
