MySQL Forums
Forum List  »  Newbie

login function select * from 2 tables
Posted by: seek henry
Date: February 11, 2009 10:14PM

Hi, can any1 help me about this,
i going to make a login function.
i got 2 tables

table a
username user1,usesr2
password yyy ,yyy

table b
username name1,name2,abc
password xxx ,xxx ,123

currently my system can run to login, but database is from table a only,that means
i cannot login with username abc, password 123.

This is the select part in my function,
$q = "SELECT password FROM a WHERE username = '$username'";
$q = "SELECT username FROM a WHERE username = '$username'";

i want to select both database so i can login using either table a data or table b data,so how to let the engine select * from 2 tables??

Thanks for ur help..

Options: ReplyQuote


Subject
Written By
Posted
login function select * from 2 tables
February 11, 2009 10:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.