[EMAIL PROTECTED] wrote:
How do I check two tables is it? Username and userpass are submitted through a
from and are unique
$sql = "SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND
userpass = '$userpass'";
This way you'll have an ambiguous error as username and userpass belongs
to both table (as far as I could understand). You can do both selects or
do something like this:
select a.user, a.pass, b.user, b.pass
from table1 a, table2 b
where (...)
Or create a MERGE storage engine if both your tables are identical:
http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html
cheers,
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
