accessing different columns with the same name when joining tables

[mr_burns]

hi,

i have two tables that i am joining using the following sql:

SELECT * FROM clients, programmes WHERE clients.client_id =
programmes.client_id AND programmes.client_id = 12
if both clients table and programmes table contain a column called
date_added, how do i access them both seperately? i have tried the
following:

//after connect code etc.

while ($row = mysql_fetch_array($result)) {
$clients_date_added = $row['clients.date_added'];
}
....but it doesnt seem to work. any help?

cheers

burnsy

[Marcin Dobrucki]

mr_burns wrote:

i have two tables that i am joining using the following sql:

SELECT * FROM clients, programmes WHERE clients.client_id =
programmes.client_id AND programmes.client_id = 12
if both clients table and programmes table contain a column called
date_added, how do i access them both seperately? i have tried the
following:

//after connect code etc.

while ($row = mysql_fetch_array($result)) {
$clients_date_added = $row['clients.date_added'];
}

...but it doesnt seem to work. any help?

There is going to be a collision, instead, use something like this:

SELECT clients.date_added as c_date_added, programmes.date_added as
p_date_added FROM ...

/marcin

[Phil Roberts]

bi******@yahoo.co.uk (mr_burns) emerged reluctantly from the
curtain and staggered drunkenly up to the mic. In a cracked and
slurred voice he muttered:

<snip>

...but it doesnt seem to work. any help?

SELECT c.date_added AS clients_date_added,
p.date_added AS programmes_date_added
FROM clients c, programmes p
WHERE c.client_id = p.client_id
AND p.client_id = 12

while ($row = mysql_fetch_array($result)) {
echo $row['clients_date_added'];
echo $row['programmes_date_added'];
}

You were almost there. However if you wan't to select any more
columns you'll need to explicitly name them.

--
Phil Roberts | Deedle Doot Doo Dee Dee | http://www.flatnet.net/

I could be wrong here, You could be right
Please forgive me I have sinned - Not on your life
But that's how you want me, But I'll never fear thee
Why you and not me? Tell me Holy Man