Hello

I have the following text in my mySQL database...

"Prices from: £1350.00 + VAT"

I use the following code to insert it into my web page...

"<?php echo $row_rsProdList['desc_pro']; ?>"

But the following is displayed online ...
"Prices from: �1350.00 + VAT"

Can anyone let me know where my problem is?

Cheers

Paul

Because £ must be trasformed to the HTML entitie &pound;
You'll have to use str_replace() or htmlentities() on every strings coming from your db that could contain this character.

Tripy

Many thanks, problem now solved!!!

Cheers

Paul

Opps another small problem I also want to incorporate nl2br funcation...

Currently I have...
"<?php echo htmlentities($row_rsProdList['desc_pro']); ?>"

But also want the following built in...
"<?php echo nl2br($row_rsProdList['desc_pro']); ?>"

Any ideas Tripy?

Cheers

Paul

Okay problem solved again...

"<?php $temp = htmlentities($row_rsProdList['desc_pro']);
echo nl2br($temp) ?>"

..well thats my way of doing it, is there a better / more simple way?

No, I would almost have done it that way too. Just chained the functions calls:

PHP Code:

"<?php echo nl2br(htmlentities($row_rsProdList['desc_pro']));?>"