RE: [PHP-DB] odbc query with single quote in string

2003-02-05 Thread Squirrel User
The 1st one didn't work, but the 2nd one did work. Fantastic! Thanks alot, you saved me from frustrations. Quoting "John W. Holmes" <[EMAIL PROTECTED]>: > > I'm having problem querying a table with a field value containing an > > appostropy, please help. Using ODBC to connect MSAcess database

RE: [PHP-DB] odbc query with single quote in string

2003-02-04 Thread John W. Holmes
> I'm having problem querying a table with a field value containing an > appostropy, please help. Using ODBC to connect MSAcess database. > >$mQuery = "CustomerID='$mCust'"; >$mCur2 = odbc_do( $mCnx, "select Login from Emails where $mQuery" ); > > When it hits "O'Donald, James", I get er

[PHP-DB] odbc query with single quote in string

2003-02-04 Thread Squirrel User
I'm having problem querying a table with a field value containing an appostropy, please help. Using ODBC to connect MSAcess database. $mQuery = "CustomerID='$mCust'"; $mCur2 = odbc_do( $mCnx, "select Login from Emails where $mQuery" ); When it hits "O'Donald, James", I get error in odbc_e