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
> 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
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