I'm looking for a way to do the following:
I have two tables: 'employee' with e.username and e.userid (along with a lot of other info) and 'password' with p.userid and p.password.
UserID is the link between table 'employee' and table 'password'. p.userid = e.userid
I want to have an authentication page where people type in their username (e.username) and their password. (p.password).
So, I have to combine the two tables in one query. Could someone help me?
I have the two seperate queries already, but I don't know how to combine them:
WHERE e.username = $PHP_AUTH_USER
WHERE p.password = $PHP_AUTH_PW and p.userid = e.userid