hey guys i keep getting a diamond with a question mark in it(�) every time I try and print out a value from my database. I thought it was something to do with the pound symbol so tried to change it for its code but thats giving me the same symbol(�).
$sal = str_replace(“£”, “£”, $row[5] );
echo “<b>Salary : </b>”.$sal.“<br />”;
Anyway got any ideas?
bump bump
Can you pop up a SHOW CREATE TABLE [I]product[/I] here please - where product is the name of your table.
hi anthony, i just added this to my header
<meta http-equiv=“Content-Type” content=“text/html; charset=utf-8”>
didn’t have one before. in the above post the forum converted my code to the pound symbol. the above char set doesnt work what should i be using, if that is my problem?
thanks,
Darren.
What character encoding are you using Darren? Also, the HTML entity for £ should be & pound ; with no spaces.
is there char set my problem lol
did u mean get the table info? 
CREATE TABLE `jobs` (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(100) NOT NULL,
desc varchar(1500) NOT NULL,
location varchar(40) NOT NULL,
type varchar(40) NOT NULL,
sal varchar(30) NOT NULL,
date varchar(10) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=486 DEFAULT CHARSET=latin1
Hey Anthony, thanks for bearing with me on this.
I’m not sure what your asking me to do.