Dobromir Velev
-Original Message-
From: Mike Gifford [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, July 12, 2001 4:31 AM
Subject: [PHP-DB] Left Join is producing duplicate results - MySQL
relational tables
Hello,
I posted this to the general list this morning
!
-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.
mysql_query(SELECT
I've expanded the code.
Mike
-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: 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,
WLPbib.title,
WLPbib.publisher
Hello,
I posted this to the general list this morning got a couple of good leads, but
they weren't able to actually fix the problem, so I'm posting here to the db list.
I'm making some headway on joining three MySQL tables.
However, when I run this query:
mysql_query(SELECT
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 they
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
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
[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 learn a few too many things at once. Switching it around
eliminated
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
//
//
// Sorry Ken,
//
// I'm
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
//
//
// Sorry Ken,
//
// I'm trying to learn
11 matches
Mail list logo