PHP with Access -- I know, I know, but its development
Posted: Fri Aug 22, 2003 12:12 pm
I have a select statement:
$query="select f_name, password from user_t where email = ' ".$email." ' ";
Once executed I run the 'isset' function to make sure it has been executed. Now How do I know how many rows are returned?? Cause if the passwords arent equal (from the query and what the user has entered) then I want to display 'invalid password' HOWEVER, if the f_name doesnt exists with the specified email, then I want to alert the user that the user name doesnt exist. what other functions can I uses to check that... keep in mind I am using access for the time being.
Thanks
$query="select f_name, password from user_t where email = ' ".$email." ' ";
Once executed I run the 'isset' function to make sure it has been executed. Now How do I know how many rows are returned?? Cause if the passwords arent equal (from the query and what the user has entered) then I want to display 'invalid password' HOWEVER, if the f_name doesnt exists with the specified email, then I want to alert the user that the user name doesnt exist. what other functions can I uses to check that... keep in mind I am using access for the time being.
Thanks