RE: [PHP-DB] Remove newlines from field
| From: | Bastien Koert | Date: | Mon, 20 Mar 2006 22:11:12 +0000 |
| Subject: | RE: [PHP-DB] Remove newlines from field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41552@lists.php.net to get a copy of this message | ||
see the nl2br function in the manual (www.php.net/nl2br)
bastien
From: "Giff Hammar" <ghammar@certifiedparts.com> To: <php-db@lists.php.net> Subject: [PHP-DB] Remove newlines from field Date: Mon, 20 Mar 2006 17:00:49 -0500 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/> mailto: ghammar@certifiedparts.com V: 603.516.1707 F: 603.516.1702 M: 603.490.7163