RE: [PHP] MySQL Alias and PHP

> -Original Message- > From: Charles Kline [mailto:[EMAIL PROTECTED] > Sent: Viernes, 07 de Marzo de 2003 05:48 p.m. > To: Barajas, Arturo > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL Alias and PHP > > > Wow. That is ALMOST it. The only thing is it does not

Re: [PHP] MySQL Alias and PHP

-- Un gran saludo/Big regards... Arturo Barajas, IT/Systems PPG MX (SJDR) (427) 271-9918, x448 -Original Message- From: Charles Kline [mailto:[EMAIL PROTECTED] Sent: Viernes, 07 de Marzo de 2003 04:09 p.m. To: Jim Lucas Cc: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL Alias and PHP Thanks f

RE: [PHP] MySQL Alias and PHP

4:09 p.m. > To: Jim Lucas > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL Alias and PHP > > > Thanks for all the suggestions, I have tried all and more and still > can't get this quite right. If there is a better forum for these > question, please point me

Re: [PHP] MySQL Alias and PHP

same. Jim - Original Message - From: "Charles Kline" <[EMAIL PROTECTED]> To: "Rich Gray" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 07, 2003 10:03 AM Subject: Re: [PHP] MySQL Alias and PHP Thanks for the help. Almost there. Here is what I have:

Re: [PHP] MySQL Alias and PHP

Then the information in the DB is the same. Jim - Original Message - From: "Charles Kline" <[EMAIL PROTECTED]> To: "Rich Gray" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 07, 2003 10:03 AM Subject: Re: [PHP] MySQL Alias and P

Re: [PHP] MySQL Alias and PHP

Thanks for the help. Almost there. Here is what I have: SELECT x.id, x.headline, x.description, a.area area_a, b.area area_b FROM tbl_funding x, tbl_dra a, tbl_dra b GROUP BY x.id LIMIT 0 , 30 The problem is that $array[area_a] and $array[area_b] display the same info. On Friday, March 7, 2

RE: [PHP] MySQL Alias and PHP

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

[PHP] MySQL Alias and PHP

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