Youtor
PHP MySql multiple Count statements
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=qKRYEcpmOJQ
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
#############################
