carriage return conversion

[Anon]

Ok, I'm very painfully importing an old flat file DB from and old cgi script into a mysql DB with php scripting.

Now the problem that i'm running into is that i need to somehow maintain the carriage returns that are currently present so that the data shows up a paragraphs on the screen.

The carriage returns show up in the DB as ascii "%0D%0A%0D%0A". when i pull the data to the screen, it just prints the %0D%0A%0D%0A rather than making the necessary carriage returns.

Can anyone lend a hand?

thanks

[Anon]

ahhh!,

use the str_replace() (i think) and replace the hex codes with /n or whatever =)