see the nl2br function in the manual (


From: "Giff Hammar" <[EMAIL PROTECTED]>
To: <>
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


Giff Hammar
IT Director
Certified Parts Warehouse <>
V: 603.516.1707
F: 603.516.1702
M: 603.490.7163

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to