Posted by gentleJuggernaut on 08/07/07 14:38

On Aug 7, 10:19 am, ZeldorBlat <zeldorb...@gmail.com> wrote:
> 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']

thanks

[Back to original message]