Selecting from multiple tables

[Waizujin]

I have been working on my game and I have code like this:

Code: [Select]

$grabItem = mysql_query("SELECT * FROM equipment_inventory AS inv, equipment_templates AS temp WHERE inv.item_id = temp.item_id");
$item = mysql_fetch_array($grabItem);

Now, assume I want to grab the value item_id from the inventory and the templates table using this code

Code: [Select]

echo $item['user_id'];
Well, as you can see, there are 2 user_id values. One from inventory and one from templates. How would I force it to grab from one or the other table? I tried

Code: [Select]

echo $item['inv.user_id']; and I had no luck...

[Nox]

Afaik in case of duplicit names you must alias them (equipment_templates.id as temp_user_id)

what's the purpose of user_id in equipment template?

[Chris]

You really should redesign your database schema, all "user_id" should point to the same data, so it does not matter from which table you read it.

BTW,  equipment_templates shoud never hold user_id or any other user indication, since it is a global description table not connected to user.

If you don't want to then aliases as Nox described.