MySQL Alias and PHP
| From: | Charles Kline | Date: | Fri, 07 Mar 2003 15:58:58 +0000 |
| Subject: | MySQL Alias and PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-138644@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