 |
 |
Find a programming school near you
php-general | 2001072
Date: 07/22/01
- Next message: Kyle Smith: "[PHP] Automatic survey"
- Previous message: Jeff Oien: "RE: [PHP] Control Structure Problem"
- In reply to: Philip Murray: "Re: [PHP] $this->db->Record["WLPcountry.name"]"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
That did the trick Philip! Thanks for your help.
Mike
Philip Murray wrote:
> ----- Original Message -----
> From: "Mike Gifford" <mike <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 - webmaster <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: php-general-unsubscribe <email protected> For additional commands, e-mail: php-general-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Kyle Smith: "[PHP] Automatic survey"
- Previous message: Jeff Oien: "RE: [PHP] Control Structure Problem"
- In reply to: Philip Murray: "Re: [PHP] $this->db->Record["WLPcountry.name"]"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
