Hi there I was trying to display a DB table into block on concrete5 page.

Now I couldn't find an Add-on to do this so I used the PHP code block.
I came across lots of errors and problems with this but using the mysql_connect command and an external style sheet to formate the results. I got it working and displaying the content in a nice table.

My next problem was that the £ signs were not displaying correctly and came up as crazy characters.

So next I injected this code after a long look,
mysql_set_charset('utf8',$dbname);

this then gave me the £ sins which was nice.


How ever I know found that these characters are appearing but not on every line break.

\r\n I think this is meant to be a Line BRK I am not sure.. I don't need the Break just a space would do I have tried using the replace CMD but it doesn't work any ideas?

The page is here:
http://new.usp.net/index.php/domain-names/premium-domains-for-sale/...

Also can any one tell me if this is secure?

Thanks for any help

Carl Lee