Hello all. I have a "blob" of data that is importing fine into mysql from Access, but when I output to a browser it loses all of it's formatting. All the returns and line spaces are gone. Does anyone know why? Or better yet.. how to correct it? Should I put html tags in the body text of the fields in Access?
Depends on what you want. It's usually sufficient to just call nl2br() on the data before displaying it. But you may have some special reason why converting before storing would be important.
Is that a function? Where in my sql/php would I put that?
Yes, it's a function: read all the gory details in the FM.
As far as where to put it, assuming you have retrieved the value you want into $text, where you are currently saying:
echo "Text: $text";
you would instead say
echo "Text " . nl2br($text);
