see the nl2br function in the manual (www.php.net/nl2br)
bastien
From: "Giff Hammar" <ghammar@xxxxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: 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@xxxxxxxxxxxxxxxxxx
V: 603.516.1707
F: 603.516.1702
M: 603.490.7163
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
