please help me in run sql on odbc DB

[vahidi]

hi,

I have an access table that's name is INFO with this structure:

fname text
lname text
address text
tel_no Number
act yes/no
markaz text

I have to run this Instruction:

$sql="SELECT Info.markaz,Info.tel_no FROM Info WHERE ((Info.markaz= "test"));";

$result=odbc_do($db, $sql);

but, on odbc_do line this error ecurred:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

Please help me, thanks🙂

[Lars_Berg]

sql="SELECT Info.markaz,Info.tel_no FROM Info WHERE Info.markaz= 'test'";

[vahidi]

thanks for your help,
by this work , this error eccured:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Info.markaz= 'test'''., SQL state 37000 in SQLExecDirect