Multiple select

Question

i have two tables one is for user and second one is for admin and a common login page with username and password ..i want that query when user or admin fill there login credential and press login button then which table matches the login credential there data should be fetched so what should be the query

Answer 1

I would recommend to use only one table for that and add a column "admin" with (INT) 0(User) and 1(Admin). This would be easier :)

Answer 2

thankyou thomas ..btw why every one uses only one table

Answer 3

It's easier and you don't need to Join or even check twice the Database Tables. Smaller Code and Faster. :)