ornemann
>
> -Oprindelig meddelelse-----
> Fra: Lisi [mailto:[EMAIL PROTECTED]]
> Sendt: 14. januar 2003 18:47
> Til: Ignatius Reilly
> Cc: PHP-DB
> Emne: Re: [PHP-DB] LEFT JOIN not working
>
>
> Still not working. I made the change, and I'm still getting all results.
=
'01'
(if your table ads_displayrate has such date fields).
HTH
Ignatius
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 6:54 PM
Subject: Re: [P
H(ads_displayrate.date) =
'01'
(if your table ads_displayrate has such date fields).
HTH
Ignatius
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>
Sent: Thurs
L 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 in the ON clause that select the d
m?"
D. 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
uot;)
Ignatius
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; "PHP-DB"
<[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 12:18 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
> OK
ent: Thursday, January 09, 2003 12:18 PM
Subject: Re: [PHP-DB] LEFT JOIN not working
> OK, this helped a bit. Now I have, in addition to the three rows of ads
> that have ben clicked on, a fourth row with no ad name, 0 clickthroughs,
> and 24 displays. That plus the other three account f
OK, this helped a bit. Now I have, in addition to the three rows of ads
that have ben clicked on, a fourth row with no ad name, 0 clickthroughs,
and 24 displays. That plus the other three account for all the displayed ads.
However, since it is returning a null value for any ad name that has not
problem 1:
move the WHERE clauses to the ON clauses
problem 2:
Obviously your intent with " COUNT(ads_clickrate.date) " is to count the
number of non-null occurences of click. But COUNT() is not the appropriate
function to do this (it will simply give you the number of rows inside a
group).
Try r
