Sounds like you might be using the quote() method with placeholders.
If so, don't. When using placeholders you don't need to use quote().
Use mysql (the command line app) to see what the data looks like
in the db.
Tim.
On Thu, Mar 27, 2003 at 11:19:04AM -0500, Brian Spindler wrote:
> Hi guys, gals!
>
> I have a pretty big string that I am inserting into MySQL via the
> $dbh->quote($str) function, this works great however now when I pull the
> data back out of the database and go to write it to a file the \n characters
> that were inserted by quote are not being written back out as carriage
> returns as desired. How can do a reverse of quote() or just get those
> "\n"'s to print out as they should! =) ahh.. I'm frustrated, I tried
> everything even split('\n',$str) and then reinserting the "\n". Doesn't
> work, please help!
>
> Thanks in advance!
> Brian
>