comparing textbox input with database?

deebs1000

hello

i am trying to write a script that will compare the contents of a text box in a form, to a field in an access database.
if it matches, then proceed with the forms action, if not, display a message saying "please enter the correct password" or "please register"

i have gotten this far but i am getting an error:

<?

$membername=$POST['membername'];
$password=$POST['password'];

#connect to DSN
$connect=odbc_connect("user_details_input","","");

$task = "SELECT * FROM".
"[users_table] WHERE ".
"[membername] = '".$POST['membername'].
"' AND [password] = '".$POST['password']."'";

$result = odbc_execute($task);

$resultcount = odbc_record_rows ($result);

if ($resultcount == 1) {

Valid user

}

elseif ($resultcount > 1) {

Duplicate user in the DB

}

else {

Invalid user

}
?>

but i am geeting this error:

Warning: odbc_execute(): supplied argument is not a valid ODBC result resource in C:\XITAMI\webpages\22\test.php on line 24

Fatal error: Call to undefined function: odbc_record_rows() in C:\XITAMI\webpages\22\test.php on line 26

dopey

Hi,

according to http://www.php.net/odbc_execute you have to prepare your statement first, using odbc_prepare().

Or looks like you can use odbc_exec() (http://www.php.net/odbc_exec) to execute the sql without a odbc_prepare()

deebs1000

i am a bit of a newbie, how should i fit that into the code i have given above

dopey

Not tested, but something along the lines of:

$connect=odbc_connect("user_details_input","",""); 

$task = "SELECT * FROM". 
"[users_table] WHERE ". 
"[membername] = '".$_POST['membername']. 
"' AND [password] = '".$_POST['password']."'"; 

$result = odbc_exec($connect,$task); 

$resultcount = odbc_record_rows ($result);

deebs1000

thanks for replying

that code processes this error:

Fatal error: Call to undefined function: odbc_record_rows() in C:\XITAMI\webpages\22\test.php on line 27

what should i do now?

dopey

Try odbc_num_rows() instead (http://www.php.net/odbc_num_rows)

deebs1000

but how would i incorporate it into my that script above dopey.

sorry, i am a bit of a newbie