> -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
--
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
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
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:
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
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
> 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_
7 matches
Mail list logo