|
|
Posted by Jerry Stuckle on 03/02/06 14:26
Bosconian wrote:
> "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.
>
>
So? You have a cms which uses MySQL. I can point you to other products
which use Postgres. Does that mean PHP and Postgres are "virtually
joined at the hip"? Or maybe Oracle? Or MSSQL? There are other
products which use each of these with PHP.
PHP is a programming language. MySQL is a database manager. Two
entirely different products which work well together.
And two entirely different newsgroups.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|