Modifying Delimiter Characters

[jumpingmatflash]

Hi there,
I'm trying to write a script which imports a CSV file and adds it to a database. However i've come across some problems.

The CSV file contains names and addresses. Some of the names include the '[\B] character and cause problems for the insert to the database portion of the script.

I've tried using the following but it still fails

$name would be something like o'grady

$search_string = "\'";
$replace_string = "\\'";

$name = str_replace($search_string,$replace_string,$name);

the replace string contains two backslashes before it but this forum doesn't display the characters.

[jumpingmatflash]

Many thanks,

the mysql string function couldn't be used as i'm using a postgres sql DB but the add slashes works a treat! It's worked so well it's shown me the flaws in my DB schema

Thanks again, Matt