im doing project for a school...and new to php and mysql..just learning..
i have to create one loginpage with 3 different users like corres,principal and the staff
in the table field what type i have to give like ENUM or SET..
i want to assign 0 for corr,1 for princi and 3 for staff..
how to do this and shud i give any field in the login page in php??
but im going to create only 2 tables one for corr and other one is for staff
correc table fields r corrs_id,username,password,staff_id,staff_role
staff table fields r staff_id,staff_role,name,qualification,address,state etc...
both the tables have 2 common fields staff_id and staff_role
now how to connect 2 tables and when username and password is given it shud first check the staff_role like princ or a staff
please help me....