how to remove special characters
Montréal-Rive-Sud
the above one is city name this i'm getting from xml feeds. It is directly inserting into my mysql database. now i want to remove this kind of special characters.
You need the mysql_real_escape_string()