I am having a coding issue with checking multiple passwords from a mysql database using php3. I would like to have 4 different passwords for one user. Do any of you know of a way i could do this. For instance a
username: jack
could use passwords: dog, cat, cow, rat
I have a username field and a password1-5 fields for each id.
Is thier an or clause in the mysql_query function using select. For instance i tried this and it doesnt work
mysql_query("select id from user_table where username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW' or password2='$PHP_AUTH_PW' or password3='$PHP_AUTH_PW' or password4='$PHP_AUTH_PW' or password5='$PHP_AUTH_PW'",$conn);
That statement doesnt seem to work. Any suggestions.
Thanks for any help.
Ira
username: jack
could use passwords: dog, cat, cow, rat
I have a username field and a password1-5 fields for each id.
Is thier an or clause in the mysql_query function using select. For instance i tried this and it doesnt work
mysql_query("select id from user_table where username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW' or password2='$PHP_AUTH_PW' or password3='$PHP_AUTH_PW' or password4='$PHP_AUTH_PW' or password5='$PHP_AUTH_PW'",$conn);
That statement doesnt seem to work. Any suggestions.
Thanks for any help.
Ira