[eluser]danmontgomery[/eluser]
When you SELECT * and join tables, it selects all columns from all tables. Assuming all of the tables have an ID column, when that result set is translated to PHP, each ID column will overwrite the previous one. If you only need the data from table, you should specify that table:
If you need the data from other tables as well, you can just alias those ID fields
Code:
SELECT *, files.id AS file_id, users.id AS user_id