odbc error..

[stezz]

Hey!

Im trying to query an access database for a username and password. I posted something here a few days ago about a supplied argument. That has been sorted now, thanks!

Could somebody please tell me what the following error means?

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in c:\documents and settings\stezzy\desktop\files\projects\fsm\login.php on line 9

For reference, line 9 is..

$result = odbc_exec($connect, "SELECT ID FROM tblusers WHERE Username = $user AND Password = $pass");

Thanks!

Regards, Stezz.

[dalecosp]

Hmm, is the odbc syntax that different from MySQL?

Or, does $user and $password need to be '$user' and '$password' ??

[saidbakr]

I think you must place $user $pass between single quote :
$result = odbc_exec($connect, "SELECT ID FROM tblusers WHERE Username = '$user' AND Password = '$pass'");
This's because Strings must be inside single quote ' in SQL.🙂