php +newlines+mysql
| From: | adi | Date: | Mon, 08 Jul 2002 07:49:12 +0000 |
| Subject: | php +newlines+mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-106040@lists.php.net to get a copy of this message | ||
I have a problem in php page:
i want to insert into mysql database value $string with newlines:
$string="-line1\n -line2 \n-line3";
$result2 = db_query("update table1 set column1= '$string' where ID =
'$IDcurent'") or db_die();
When i try to view in a textarea control the new value from column1, the
newlines
disappear!
ps.column 1 have type "text" or "varchar(100)"
Is a problem of type?
tx in advance for any help
adi