Apostophes and Obdc Connections

[freebsd_dude]

Hello Everyone,

I have a problem with Apostophes in varibles in php.
I am trying to insert data into a msaccess 2000 database running with a odbc connection.

Every time i try to add something with a Apostophes in the text i get a odbc error in my sql statement.

Example:

When I pass a varibles data to the database like tool's i get a sql error like this

It's something to do with the Apostophes.

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''tool\'s')'., SQL state 37000 in SQLExecDirect in

I am running Win2000 Server with IIS 5 and php running.

Thank you

Freebsd_dude

[batman]

Try, when you post somehting with an apostophe to put a \ in front of it.
Example:

echo"tool's";

will be replaced by

echo"tool\'s";

The reason is that according to the page it looks like it's trying to close the tag, but can't.