How do I deal with characters like " ' in mysql

[adrianuk29]

When a name is entered in to mysql database, say like cote d'azur when it is outputted to my php page it comes out like this cote d'/azur

Why is this and is there a fix I can use to stop it showing the /

The same happens if you enter an & sign in text for example
Brighton & Hove Albion

This would come out as Brighton and miss the rest of the text off.

[nicolai]

When you submit data to your database (using PHP) use addslashes($eachVariable) on each variable holding data to be put in the database.
When you select data from the database use stripslashes() to remove the again.

addslashes example:

$varToAdd = "it's a test";

$query = "INSERT INTO yourTable (theField) VALUES ('".addslashes($varToAdd)."')";
$result = mysql_query($query);

stripslashes example:

$row = mysql_fetch_array($someResult)

echo htmlspecialchars( stripslashes($row["someField"]) );

Hope this clarifies the issue.

About the second question:
Please post your query.

Best regards Nico