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