ireland's is showing up as ireland''s

Sorry beginner at this.

i've created a php site in dreamweaver and most is all well but for some
reason in one of my mysql tables I have some names that have apostrpohes
in them but when displayed on a page (or an edit form) they always are
displayed as a double apostrophe for example in the table there is a
field with data in it which is ireland's but on display it comes out as
ireland''s

can anyone shed any light on that one for me????

Adam Davies <sdfsf@Sdf.com> wrote in news:MPG.19abfc92fba859d8989682
@news.easynews.com:

> i've created a php site in dreamweaver and most is all well but for some
> reason in one of my mysql tables I have some names that have apostrpohes
> in them but when displayed on a page (or an edit form) they always are
> displayed as a double apostrophe for example in the table there is a
> field with data in it which is ireland's but on display it comes out as
> ireland''s

Must be the way you're escaping (or not) the string. You probably use the
single quote (or apostrophe) to delimit strings in your query (ie, INSERT
INTO myTable VALUES ('ireland') ). If you need to use the single quote in
your string, you have to escape it: 'ireland\'s'. It should be converted
back when you extract the value from the DB.

Another thing that might cause problems is if Magic Quotes GPC is enabled
in PHP. It'll "magically" escape input strings (GET, POST, COOKIE), and
sometimes this will mess things up.

KAH