RE: [PHP] MySQL Alias and PHP
| From: | Rich Gray | Date: | Fri, 07 Mar 2003 16:09:55 +0000 |
| Subject: | RE: [PHP] MySQL Alias and PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138647@lists.php.net to get a copy of this message | ||
> Hi all,
>
> I have this query:
>
> SELECT a.area_name, b.area_name FROM tbl_1 x, tbl_2 a, tbl_2 b
> WHERE x.area_1 = a.id
> AND x.area_2 = b.id
>
> I am using PEAR DB to get my results as an ASSOC ARRAY. How do I echo
> the values for a.id and b.id?
>
> Thnks
> Charles
>
I presume you mean area_name...
Try this -> SELECT a.area_name as area_a, b.area_name as area_b FROM tbl_1
x, tbl_2 a, tbl_2 b
Then you can refer to the columns as $array['area_a'] and $array['area_b']
HTH
Rich