Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-12 Thread Dobromir Velev
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

RE: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-12 Thread Matthew Loff
! -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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-12 Thread Mike Gifford
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 that

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-12 Thread Mike Gifford
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

RE: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-12 Thread Matthew Loff
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

[PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Ken
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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
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,

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Ken
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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Kevin Johnson
[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

RE: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Beau Lebens
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

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
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