如何计算行zend框架？

Question

Hi i'm trying to get a count of rows but no luck so far maybe there's something with the database becouse i get some strange numbers

here's the database egs

poll_id option_poll_id gender
1       100            male
1       100            male
1       103            femeale
1       103            male

so what i want is that for each option 100 and 103 to get the number of male or femeals

like this option 100 -> 2 male and option 103->1 male Thanks in advance.

Answer 1

What's your query look like? This should get you the numbers you need:

SELECT option_poll_id, gender, COUNT(gender)
FROM yourtable
GROUP BY option_poll_id, gender