isset()

[btherl]

Try this out.  It's long and messy because of the unusual database design, but it may get you what you want.  The key idea is rather than filtering rows by YES, which doesn't work because a single row can contain both YES and NO, it maps YES to 1 and NO to 0 and then adds up the total.

 

$sql = "SELECT SUM(CASE WHEN rowBa = 'YES' THEN 1 ELSE 0 END) "
. " + SUM(CASE WHEN rowBb = 'YES' THEN 1 ELSE 0 END) "
. " + SUM(CASE WHEN rowBc = 'YES' THEN 1 ELSE 0 END) "
. " + SUM(CASE WHEN rowBd = 'YES' THEN 1 ELSE 0 END) "
. " + SUM(CASE WHEN rowBe = 'YES' THEN 1 ELSE 0 END) "
. " AS cnt "
. " FROM my_db2 ";

 

But, like thorpe said, please consider redesigning the table

[RON_ron]

Thanks btherl. 

 

Is it possible to use the array created ($Array1) instead of repeating the field names?