- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Ed" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, January 05, 2007 5:23 AM
Subject: Re: [PHP-DB] Multiple Count's in one Select.
[ please don't top-post, makes it hard to follow ]
Ed wrote:
As this is a new db i've not done any
I am using CURL to check pages outside my site on the internet for some
text, then I email someone on my database who supposedly looks after the
site. The script creates a process that does not terminate. It is running
on a scheduled cronjob so eventually my site has over the maximum of 20
pr
On 1/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am using CURL to check pages outside my site on the internet for some
text, then I email someone on my database who supposedly looks after the
site. The script creates a process that does not terminate. It is running
on a scheduled cronj
Ed wrote:
SELECT DISTINCT u.*, t.*, (SELECT COUNT(jobtype) FROM taskinput WHERE
t.user_id = u.user_id ) AS 'COUNT', (SELECT COUNT(jobtype) FROM
taskinput WHERE t.user_id = u.user_id AND t.jobtype = 'Navision') AS
'Navision', (SELECT COUNT(jobtype) FROM taskinput WHERE t.user_id =
u.user_id A
- Original Message -
From: "OKi98" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 05, 2007 1:19 PM
Subject: Re: [PHP-DB] Multiple Count's in one Select.
Ed wrote:
SELECT DISTINCT u.*, t.*, (SELECT COUNT(jobtype) FROM taskinput WHERE
t.user_id = u.user_id ) AS 'COUNT', (SELECT COUNT