array with joining table. (u pro !)

[abnfire]

i have two tables one is category and other is resource and there structure is :

// start category table
id int
name
resource_id
// End category table
// Start resource table
id
name
// End resource table

my sql = " Select * from cateogry, resource where category.resource_id = resource.id";

so how do i know which id do i get in array, i mean there is two fields in two different tables, so how can i get id from category and id from resouces in the array?

[ahundiak]

Read about sql aliases.

SELECT
category.id AS category_id
resource.id AS resource_id
WHERE ...

echo $record['category_id'];