View Single Post
 
Old October 10th, 2007, 02:59 PM
crmpicco crmpicco is offline
Friend of Wrox
Points: 8,019, Level: 38
Points: 8,019, Level: 38 Points: 8,019, Level: 38 Points: 8,019, Level: 38
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default entering £ (pound sign) into MySQL database - PHP

Can anyone tell me what the issue is with inserting a pound sign (£) into a MySQL database with PHP and retrieving it back out the database?

I haven't received an error, but when I use the following code the information just stops and does not render any further:

Code:
<?php 
if (mysql_num_rows($result)) {
   $row = mysql_fetch_assoc($result);
   echo $row["moreinfo"] 
}
?>

$row["moreinfo"] contains data like 'Paid £10,000'

Cheers,
Picco


www.crmpicco.co.uk
www.ie7.com
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk