Re: [PHP-DB] LEFT JOIN not working

2003-01-15 Thread Ignatius Reilly
. 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 Su

SV: [PHP-DB] LEFT JOIN not working

2003-01-15 Thread Henrik Hornemann
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. I even tried it without the leading '0' in front of the 1, no good. Here's my current query, with suggested changes: SELE

Re: [PHP-DB] LEFT JOIN not working

2003-01-14 Thread Miles Thompson
= '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

Re: [PHP-DB] LEFT JOIN not working

2003-01-14 Thread Lisi
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

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Ignatius Reilly
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

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Ignatius Reilly
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

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Lisi
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

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Ignatius Reilly
ads_clickrate.date IS > >NULL, 0, 1 ) ) > > > >HTH > >Ignatius > >____________ > >- Original Message - > >From: "Lisi" <[EMAIL PROTECTED]> > >To: "PHP-DB" <[EMAIL PROTECTED]> >

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Lisi
Try 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

Re: [PHP-DB] LEFT JOIN not working

2003-01-09 Thread Ignatius Reilly
January 09, 2003 10:44 AM 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

[PHP-DB] LEFT JOIN not working

2003-01-09 Thread Lisi
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