On Monday 23 July 2001 11:16 am, kmurrah wrote:
> How do I add new line characters to a text field in mySQL ?
>
> i.e. i need to manually insert "returns" into my text ...
>
> thanks in advance,
>
> KennM
Does the "\n" not work? I dont have time to try it write now but did you try
it?
--
PHP
Hi,
You could put "\n" where you want the new line.
Than if you want to output the text field in HTML you could use nl2br() to
replace the new line characters with
For example take a look at this INSERT query:
$sql= "INSERT INTO table_name (text_field,...other_fields) VALUES ('first
row\nsecond
