Posted by Bosconian on 03/02/06 07:46

"no.mail.pls" <no.mail@st.peters> wrote in message
news:44067338$0$15789$14726298@news.sunsite.dk...
> Hi Steve,
>
> Thanks for the reply. It works.
> i am aware that this is not a sql group, but i beg your indulgence, as i
am
> quite sure that you guys will respond,
> because i believe that most folks who use PHP
> will also be using mysql.
>
> is that correct?
>
> cheers
> "Steve" <ThisOne@Aint.Valid> wrote in message
> news:pan.2006.03.02.04.04.02.810758@Aint.Valid...
> > On Thu, 02 Mar 2006 11:41:12 +0800, dottty wrote:
> >
> >> Hi,
> >> i have a table that has the following fields:
> >> id, name, dept, pay
> >> 1, John, Sales, 4000
> >> 2, Peter, HR, 5000
> >> etc.
> >>
> >> How do i count how many people there are in each dept with an sql
query?
> >>
> >> I find this surprisingly difficult, given the fact that i can sum the
> >> total
> >> pay for each dept by using:
> >> $query="
> >> Select sum(if (dept='HR', pay, 0)) as hrpay, ......
> >> ";
> >>
> >> TIA
> >
> > Blimey, is that sql? Given the standard rider about this *not* being a
> > mysql support group, something like the (untested) suggestion below
might
> > help:
> >
> > select dept, count(*), sum(pay) from ... group by dept, order by dept;
> >
> > Steve
> >
>
>

I'm with you. PHP and MySQL are virtually joined at the hip. Look no further
than www.opensourcecms.com for proof.

[Back to original message]