PHP + Access + getting apostrophes to go

I have been having the toughest times getting apostrophes to pass into the database. I hvae tried using str_replace("'","`");
i've tried addslashes($foo); , i've tried ereg_replace, and urlencode.

Nothing seems to work with an access database. Is there an addslashes(); command specific to ms access databases? I'm using PHP + ODBC with an MS Access database.

It was giving errors of missing operators, but now it will pass a \' or a \` but I can't do anything with that record at that point, its almost as if it gets tainted somehow.

I can paste code or whatever is needed.

Any help is so much appreciated.

For access, you may need to escape a single quote with another single quote, rather than a slash.

---John Holmes...

I would tend to concur with SepodatiCreations. adding slashes is not ANSI sql and will only work in MySQL and PostgresQL. You need to escape each single quote with another single quote.

What if i am using Perl+Sybase...

I want to insert a value from a variable into database...
But the value contains a ' (single quote) which cannot be inserted into the database...
I need to escape it with another '.....
Like for eg
variable x="O'Brien" which has to be "O''Brien".
How can i achieve this in perl?????

I have heard of "DBI placeholder"...but how do i achieve that...

Why don't you ask in the Perl forum with a new thread (or search there). I'm sure there is a str_replace() similar function in Perl.

---John Holmes...