I added DISTINCT to the code (as per below):
Kamil Choma wrote:
> Mike Gifford wrote:
>>However, when I run this query:
>>mysql_query("SELECT DISTINCT
>> WLPbib.bibID,
>> WLPbib.title,
>> WLPbib.publisher,
>> WLPbib.publicationDate,
>> WLPaddress.city,
>> WLPaddress.state,
>> WLPprofile.firstName,
>> WLPprofile.lastName,
>> WLPprofile.organization,
>> WLPcountry.languageName
>> FROM WLPbib
>> LEFT JOIN WLPprofile ON WLPprofile.profileID = WLPbib.profileID
>> LEFT JOIN WLPaddress ON WLPaddress.publisherID = WLPbib.publisherID
>> LEFT JOIN WLPcountry ON WLPcountry.countryID = WLPaddress.countryID");
>>
>>I now get results in triplicate. ie. I'm getting three copies of the same
>>title, firstName, organization, etc....
> Maybe SLECT DISTINCT ... could help you.
However not everything needs to be distinct. Just the bibID number actually.
The results this produces though are no different than without it.
Mike
--
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
