php and mysql query

[whiteyoh]

Hi all,

Im a bit stuck. I think im staring the answer right in the face but cant see it.

Im after a query that references 1 table.

Its output will be each unique source code along with a total of grouped data from a single column.

SOURCECODE Count of 'yes' count of 'no' count of 'maybe' count of 'dontknow'
1
2
3
4
5

any help would be appreciated

SELECT  source, COUNT(*) FROM accounts
AND status = '$type'
GROUP BY source

[tiggsy]

SELECT source,count(source) FROM `accounts` group by source

[whiteyoh]

Hi Tiggsy,

Thanks for the reply. That query is fine but what i want is the source name, along with how many of each status there are for that source.

The status column stores 5 different values

[tiggsy]

You might want to build the query something like this:

SELECT source,status,count(status) from (select source,status from accounts) as subset1 group by source,status