Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001072

Re: [PHP] $this->db->Record["WLPcountry.name"] From: Philip Murray (webmaster <email protected>)
Date: 07/22/01

----- 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
------------- - -- - - 

-- 
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>