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..
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.