oh right, I kinda tried that before without success, but now I see the problem wasn't with my query. I sorted everything with MYSQL_ASSOC, but both tables had same names in them. I didn't know they would overwrite eachother.
Is there anyway I can use the result type MYSQL_ASSOC without this side effect? (thus not overwriting but putting them in seperate arrays?)
This seems very logical and will surely work. I didn't know I could do that. Thanks for helping out a newbe
With PHP you can do mysql_fetch_array() to fetch a mysql result as an array. MYSQL_ASSOC is just a parameter for this fucntion. It means it will return an Associative array. (with strings as keys, instead of numbers)