: PHP-DB
Emne: Re: [PHP-DB] LEFT JOIN not working
Still not working. I made the change, and I'm still getting all results. I
even tried it without the leading '0' in front of the 1, no good.
Here's my current query, with suggested changes:
SELECT ads_displayrate.name, SUM(ads_displayrate.count
.
Ignatius
- Original Message -
From: Henrik Hornemann [EMAIL PROTECTED]
To: Ignatius Reilly [EMAIL PROTECTED]
Cc: PHP-DB [EMAIL PROTECTED]
Sent: Wednesday, January 15, 2003 10:56 AM
Subject: SV: [PHP-DB] LEFT JOIN not working
Hi,
You might want
fields).
HTH
Ignatius
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: Ignatius Reilly [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 6:54 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
Cool! It's mostly working now, the only problem
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: Ignatius Reilly [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 6:54 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
Cool! It's mostly working now, the only problem is it's ignoring the other
clauses
I have a page with many ads that stores both the number of times an ad is
displayed and how many times it gets clicked. These are stored in two
different tables (since different information is stored for each) but both
have identical name columns. I am trying to display both # times displayed
replacing COUNT(ads_clickrate.date) by SUM( IF( ads_clickrate.date IS
NULL, 0, 1 ) )
HTH
Ignatius
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: PHP-DB [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 10:44 AM
Subject: [PHP-DB] LEFT JOIN
Subject: [PHP-DB] LEFT JOIN not working
I have a page with many ads that stores both the number of times an ad
is
displayed and how many times it gets clicked. These are stored in two
different tables (since different information is stored for each) but
both
have identical name columns
. Ivester, CEO, Coca Cola
- Original Message -
From: Lisi [EMAIL PROTECTED]
To: Ignatius Reilly [EMAIL PROTECTED]; PHP-DB
[EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:11 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
Exactly my question - why
]
Sent: Thursday, January 09, 2003 6:54 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
Cool! It's mostly working now, the only problem is it's ignoring the other
clauses in the ON clause that select the desired date. Perhaps it's not
supposed to be connected this way? How would I select