php +newlines+mysql

From: 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

« previous php.general (#106040) next »