August 07, 2011 9:33 PM
To: Peter Lind
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Left Join
>On Sun, Aug 7, 2011 at 3:00 PM, Peter Lind wrote:
> >Maybe it's just me, but I can't see anything that would work as
>foreign key for you to join on - neither table seems to have a foreign
>On Sun, Aug 7, 2011 at 3:00 PM, Peter Lind wrote:
> >Maybe it's just me, but I can't see anything that would work as
>foreign key for you to join on - neither table seems to have a foreign
> >key
>
Sorry for my ignorance. How do I create the foreign key? The two columns
from each table that h
Maybe it's just me, but I can't see anything that would work as
foreign key for you to join on - neither table seems to have a foreign
key
On 7 August 2011 21:53, Chris Stinemetz wrote:
> I am tyring to build a query that will take the most recent
> "stores.store_date" column then join it with "s
Thanks. I couldn't find the correct syntax in my resources. I tried at one
point to use commas like:
select * from table1
left join table2,table3 on table1.id=table2.id,table1.id=table3.id
Thanks again for the correct syntax.
On Tuesday 12 August 2003 04:00 pm, Brent Baisley wrote:
> The left
The left join works the same for two or more tables.
select * from table1
left join table2 on table1.id=table2.id
left join table3 on table1.id=table3.id
...
Just specify the table you want to join and what to use to join them.
On Tuesday, August 12, 2003, at 03:16 PM, Michael Cortes wrote:
I kno
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
2, 2001 10:48 AM
To: Matthew Loff
Cc: 'Dobromir Velev'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Left Join is producing duplicate results - MySQL &
relational tables
Hi Matthew,
Matthew Loff wrote:
> What about...
> SELECT WLPbib.bibID,
>
h SQL, so perhaps someone can better
> elaborate.
I think that you did a good job.. However I think I'm still stuck with the same
duplicate error now (well when I've expanded the code.
Mike
> -Original Message-----
> From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
Hello Dobromir,
Dobromir Velev wrote:
> Did you try to use something like this.
> mysql_query("SELECT DISTINCT
>WLPbib.bibID,
The only item that I want to have distinct is the first one. However, I think
that Matthew's response (to your response) is working now.
> The other thing t
.
Best of luck!
-Original Message-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 3:01 AM
To: [EMAIL PROTECTED]; Mike Gifford
Subject: Re: [PHP-DB] Left Join is producing duplicate results - MySQL &
relational tables
Hi,
Did you try to use something like this.
Hi,
Did you try to use something like this.
mysql_query("SELECT DISTINCT
WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName
n drop that SQL into my script.
>
> HTH
> Beau
>
> // -Original Message-
> // From: Mike Gifford [mailto:[EMAIL PROTECTED]]
> // Sent: Thursday, 12 July 2001 11:01 AM
> // To: Ken
> // Cc: [EMAIL PROTECTED]
> // Subject: Re: [PHP-DB] Left Join is producing duplic
into my script.
HTH
Beau
// -Original Message-
// From: Mike Gifford [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 12 July 2001 11:01 AM
// To: Ken
// Cc: [EMAIL PROTECTED]
// Subject: Re: [PHP-DB] Left Join is producing duplicate
// results - MySQL &
// relational tables
//
//
fford" <[EMAIL PROTECTED]>
To: "Ken" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 08:00 PM
Subject: Re: [PHP-DB] Left Join is producing duplicate results - MySQL &
relational tables
> Sorry Ken,
>
> I'm trying to l
Sorry Ken,
I'm trying to learn a few too many things at once. Switching it around
eliminated the error message but not the duplication.
I'm eliminating as much of the code as I can to see that it isn't coming from PHP.
Thanks again for your help.
Mike
Ken wrote:
> In general, you should al
Mike -
In general, you should always be reading the manual first. From the SELECT syntax at
http://www.mysql.com/doc/S/E/SELECT.html
GROUP BY must be indicated before ORDER BY. So reverse the order of those portions.
- Ken
At 10:35 PM 7/11/01 -0400, Mike Gifford wrote:
>It looked good, but it
It looked good, but it gave me an error.. Sorry
Database error:
Invalid SQL: SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.l
Mike -
I'm not certain but it sounds like you might be looking for "GROUP BY". Do GROUP BY
and then the columns that are identical in your results.
- Ken
At 09:46 PM 7/11/01 -0400, Mike Gifford wrote:
>Hello,
>
>I posted this to the general list this morning & got a couple of good leads, but
26 matches
Mail list logo
