Hello,
I want to retrieve record from mysql database for a php web page with two or more where condition i.e
select * from branch where branch_status=' 1'
select * from branch whre branch_status=' 2'
(I need Total no of branches, status 1 br. and status 2 br. in the same row)
so that I can have the following table
--------------------------------------------------------------------------------------------------------------
Total No. Branch | No of Br with status1 | No of Br with status=2
--------------------------------------------------------------------------------------------------------------
Pleae help me.
I want to retrieve record from mysql database for a php web page with two or more where condition i.e
select * from branch where branch_status=' 1'
select * from branch whre branch_status=' 2'
(I need Total no of branches, status 1 br. and status 2 br. in the same row)
so that I can have the following table
--------------------------------------------------------------------------------------------------------------
Total No. Branch | No of Br with status1 | No of Br with status=2
--------------------------------------------------------------------------------------------------------------
Pleae help me.
Comment