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]