PHP MySql multiple Count statements

Описание: Preform multiple count statements in your database using this sql statement.
Here is the code from the video example. See all my videos on http://lenfarneth.com

SELECT (

SELECT count( md_geo )
FROM cl_doctors
WHERE md_geo = '0'
) AS count_1, (

SELECT count( md_geo )
FROM cl_doctors
WHERE md_geo = '1'
) AS count_2, (

SELECT count( md_geo )
FROM cl_doctors
WHERE md_geo = '4'
) AS count_3, (

SELECT count( md_geo )
FROM cl_doctors
WHERE 1
) AS count_4