MS access selet WHERE problem
| From: | Shane | Date: | Fri, 15 Dec 2000 00:57:05 +0000 |
| Subject: | MS access selet WHERE problem | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4483@lists.php.net to get a copy of this message | ||
Hi all
This is probably asked alot but I have looked around and can't find what I
am doing wrong
Can anyone help please.
The code I am using is
$odbc_string = "select san,longdesc from matmap where group = '$matgroup'";
echo $odbc_string;
$cur = odbc_exec($cnx, $obdc_string);
group is a text field in an Access database
When i run it I get...
select san,longdesc from matmap where group = 'brt_plis'
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax
error in WHERE clause., SQL state 37000 in SQLExecDirect in ...
Any suggestions?
If I remove the WHERE part everything works fine.