[RESOLVED] counting results from MySQL result

[perpetualshaun]

Hi,

I'm thinking there's gotta be a way to do this. I have a query like this:

SELECT response_demo011
FROM surveys
WHERE response_pcode < '999990'
AND response_completed_on != ''
LIMIT 0 , 30

In my live table, this returns 120 rows, the values in the response_demo011 field are integers, and there three different values OR null values in the response_demo011 column. Can I run this query ONCE and somehow count the number of 5's in that response_demo011 column, the number of 6's, and then the number of 7's? Or, do I need to run a separate query to get each count?

Thx,

Shaun

[Lars_Berg]

SELECT response_demo011, count(*)
FROM surveys
WHERE response_pcode < 999990
AND response_completed_on <> ''
group by response_demo011
LIMIT 0 , 30

[perpetualshaun]

Ahh... that indeed gives me the counts I was looking for when I run that query and look @ the results in PHP MyAdmin. So now now more question... how do I echo those to the screen? For example, I get results like this:

---

| response_demo011 | count(*) |

| 5 | 57 |

| 6 | 45 |

| 7 | 18 |

So what do I do w/ the results to get an array so that I can output the count by specifying the value in the demo011 field?

$complete = ???($complete_result);
echo $complete[6]??

Thanks,
Shaun