Posted by ZeldorBlat on 08/07/07 14:19

On Aug 7, 10:08 am, gentleJuggernaut <url...@gmail.com> wrote:
> I have joined two tables in a SQL statement and retrieved the
> recordset using mysql_fetch_assoc. Now how do I refer to a field
> called time_stamp from table A when there is a field called
> time_stamp in table B. I have tried things like
> $row['A.time_stamp']; but it does not seem to work. Can anyone direct
> me to the appropriate documentation?
>
> Thanks,
>
> NSM

You alias it to something else in the query itself:

select a.timestamp as timestampA, b.timestamp as timestampB
from a, b
where a.id = b.id

Then refer to it by its aliased name:

$row['timestampA']

• Next in forum: How to sort the search-result of ldap?
• Prev in forum: How do you specify a field in a table join that has the same name as another field?
• Thread view: Re: How do you specify a field in a table join that has the same name as another field?

[Reply to this message]