Query two tables in PHP

[Anon]

Hi, can anyone tell me how I would write a query so that it would pick data from two tables in PHP using MYSQL.

[tomhath]

Check any SQL manual for how to do a JOIN.

php doesn't know of care how many tables are involved in the SELECT.

[Anon]

To pick data from two tables there must be relationship between them.

Ex.
Table1 Primary key ID
This ID is used as a foreign key in Table2 provided that the relationship between table1 -> table2 is One-to-Many.

The query can be:
select * from table1, table2 where table1.ID = table2.ID;
......