That did the trick Philip! Thanks for your help.
Mike
Philip Murray wrote:
> ----- Original Message -----
> From: "Mike Gifford" <[EMAIL PROTECTED]>
>
>>Hello,
>>
>>I'm using phplib to add functionality to my bibliography app. However I'm
>>
> not
>
>>sure how to deal with selected data from different tables with the same
>>
> field name.
>
>>The example I provided in the signature was:
>>$this->db->Record["WLPcountry.name"]
>>
>>
> > Which needs to be differentiated from:
>
>>$this->db->Record["WLPpublisher.name"]
>>
>>Any suggestions would be useful...
>>
>>
>
> You can use the AS keyword to rename the fields to whatever you want, for
> example:
>
> SELECT
> WLPbib.bibID,
> WLPbib.title,
> WLPbib.publicationDate,
> WLPbib.URL,
> WLPpublisher.name AS publisher_name,
> WLPaddress.city,
> WLPaddress.state,
> WLPaddress.countryID,
> WLPcountry.name AS country_name,
> WLPprofile.firstName,
> WLPprofile.middleName,
> WLPprofile.lastName,
> WLPprofile.organization
> FROM
> WLPbib
>
>
> So then, you'd have:
>
> $this->db->Record["country_name"]
>
> and
>
> $this->db->Record["publisher_name"]
>
> Hope this helps!
>
> Cheers
> -------------------------------- - -- - - -
> Philip Murray - [EMAIL PROTECTED]
> http://www.open2view.com - Open2View.com
> ------------- - -- - -
>
>
--
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]
