[Resolved] Accessing Data Selected from Multiple Tables

[aaron_karp]

The way to do this slipped my mind...

So I've selected some data from two tables as follows:
"SELECT * FROM users, tracks WHERE trackID = tracks.ID"

Both the users and tracks tables have "ID" columns. How do I access the value of users.ID ?

If there was only 1 table, $myarray['ID'] would work. But with two tables.....

Thanks!

[nemonoman]

Make the value required explicit:

SELECT users.id FROM ...
etc.

If you want everything, go ahead and use star:

SELECT *, users.id FROM...etc.

Then $row['users.id'] should have the value