[RESOLVED] Duplicate Field Names Return In $result
Posted: Thu Jun 15, 2006 12:26 am
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
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