At the moment I am creating a Membership Site. When a member login to the site:
Account Number:
Password:
Automatically the account of the member will display. I am currently on this but I have a problem. I am trying to connect to 2 tables on the same instance of MySQL from 1 PHP script. This table is relational in one database.
Any other ideas?
If the tables are in one and the same database then simply use JOIN operator.
If the tables are in different databases then you can do:
SELECT t1.fieldname1, t2.fieldname2
FROM `database1`.`table1` t1
JOIN `database2`.`table2` t2 on (...)
WHERE ...
Of course you have to had corresponding access rights, for the databases and the tables.