Re: [PHP-DB] Multiple Count's in one Select.

- 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

[PHP-DB] CURL and process not finishing

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

Re: [PHP-DB] CURL and process not finishing

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

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(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

Re: [PHP-DB] Multiple Count's in one Select.

- 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