[PHP] php +newlines+mysql

[adi]

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




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] php +newlines+mysql

[Analysis Solutions]

On Mon, Jul 08, 2002 at 10:49:12AM +0300, adi wrote:

  $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!

Werid.  Should work fine.  I just ran a test to make sure.  Yep, no 
problem.  Do a reveal source on your output and paste it into a reply to 
the list so we can see what you're getting.

Perhaps you're not actaully updating the data due to a mismatch in your
where ID = '$IDcurrent' statement (or some other similar problem)?  
Please make sure of that (by changing the test string to something else)  
before doing anything else.

--Dan

-- 
   PHP classes that make web design easier
SQL Solution  |   Layout Solution   |  Form Solution
sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php