> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php