Textarea and adding carriage returns

[kensmith]

I paste and copy articles in to a textarea. When I save it to a MYSQL table and then re-read the data, it is all strung together.

 

If I physically type <br> after each carriage return, I get the expect results.

 

How can I do this without having to type <br> manually?

 

Thanks, Ken

[obsidian]

I paste and copy articles in to a textarea. When I save it to a MYSQL table and then re-read the data, it is all strung together.

 

If I physically type <br> after each carriage return, I get the expect results.

 

How can I do this without having to type <br> manually?

 

Thanks, Ken

185485[/snapback]

check out the nl2br() function. if you input the textarea value as nl2br($textareaValue), it will change all the newlines to <br /> for you!

[kensmith]

check out the nl2br() function.  if you input the textarea value as nl2br($textareaValue), it will change all the newlines to <br /> for you!

185491[/snapback]

 

Thanks, that worked great. Now I have to go through my 200+ articles and remove the <br> from all of them! LOL

 

Thanks.

[Pilot-Doofy]

Thanks, that worked great. Now I have to go through my 200+ articles and remove the <br> from all of them! LOL

 

Thanks.

185496[/snapback]

You can just do this:

 

// replace <br> with <br /> even though i dont know why lol

## get all the stuff from the database

$text = $array_retrieved_from_database['field']; // change this to fit
$cur_id = $array_retrieved_from_database['field_id']; // change this to fit
$text = str_replace("<br>", "<br />" $text);

mysql_query("UPDATE table SET field = '$text' WHERE id = '$cur_id'");

 

Hope that helped.