Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
June 19, 2005, 11:28 pm
rate this thread
I'm new to PHP and I have a question that I think has a simple answer
but I just can't figure it out so I'm really hoping that one of you
gurus can help me out.
I'm trying to return data from mysql database. I have over a thousand
records and each record has a "type" field with values ranging from 1
I'm setting up an html table that has 9 cells and all I want to do is
count the total amount of types. For example, there are 140 records as
type 1, 300 records as type 2 etc.
Do I need to do 9 database querys or can this be done with one query?
Any and all help is appreciated!
Re: Counting number of matches with one database query?
select type, count(type) from mytable group by type order by type;
This has the advantage or disadvantage, depending on how you look at it,
of not returning a row for any type with NO records for it, and it also
returns rows for type 11 which is actually a mistype for type 1.
Another variant of this, good for "top 10" lists:
select type, count(type) as cnt from mytable group by type order
by cnt limit 10;
Gordon L. Burditt
- » links pointing on PHP manual not shown in error messages
- — Previous thread in » PHP Scripting Forum