How to Retrieve Record from Two Tables in PHP??

How to Retrieve Record from Two Tables in PHP??

When you want to retrieve record from different table of same database in PHP then don’t worry.

Here our team give you solution for that problem.

You can easily retrieve record from two table using join query. There are three types of join available in SQL.

·         Inner Join

·         Outer Join

·         Cross Join

For example if you want to retrieve record product from prd table and category from cat table then you can fire below query.

Select procuct.prd,category.cat from prd,cat where catid.prd=catid.cat

In above query prd and cat is table name

To retrieve record from two tables where clause is most important.

http://edusubject.com/

http://crazyjob.in/