SQL Query

[markstangroom]

I am trying to find a simple way PHP can extract data from a simple SQL table with just one select statement.

I have a field in a table intoo which users input a two letter code. There are forty of these codes.

What I want to do is count and get a total for each code.
i.e 24 AA's, 12 BB etc.

Is it possible to run one query "select * from subjectcode" and then get php to do the counting for each code?

Thanks
Mark

 

[KarveR]

select your_code,count(your_code) from yourtable group by you_code;

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ericbrunson]

That wouldn't work in oracle, I'm not sure if it would work in mysql.

select your_code, count(0) from your_table
group by your_code;

 

[KarveR]

definately works in mysql

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.