format text saved into a database

[Anon]

Hi,

Could somebody please tell me how to save line returns into Mysql ?

Let me explain : When I save text into Mysql that has line returns, it's all on the same line when I see it on my page.

Is there a solution to automatically print a "<br>" or "<p>" into Mysql so that the text gets formatted right ?

Thanks in advance,

Helene

[Anon]

$text = nl2br($res_array[\"text\"]) ;
printf(\"%s\",$text);

this code above will force line breaks to make the text fit inside of a constrained box. The function is nl2br($whatyouwanttoprint)

or you could use pre tags whihc will print text as it was pre formatted

printf(\"<pre>$text_to_print</pre>\");

good luck enjoy
peace and balance,
J