Page 1 of 1

[RESOLVED] Duplicate Field Names Return In $result

Posted: Thu Jun 15, 2006 12:26 am
by tmaiden
I have a SELECT query that returns the same field name from 2 different tables.

Example:
SELECT a.*, b.*
FROM a
INNER JOIN b ON b.id = a.id

It returns all of the fields in the 2 tables but,
when I use $row['id']
how can i tell php which id i want... im my case I want a.id
but $row['id'] actually returns b.id

Thanks

HOPE TITLE WASNT MISLEADING

Posted: Thu Jun 15, 2006 12:40 am
by tmaiden
row[0]

worked.