[SOLVED] Showing data from 2 joine tables

[alex_funky_dj]

Hello,

 

I've 2 tables with the following structure :

 

Table 1 name : categories

Fields : id, code, name.

 

Table 2 name : Products

Fields : id, category_id, code, name

 

and here's MySQL query :

$query="SELECT *
FROM products
INNER JOIN categories
ON products.categpry_id = categories.id";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

Now, I've the problem with "echo ()" !!

when I make :

 echo $row[name]; 

it shows the name of product, how can I show the category name ??

I tried

 echo $row[categories.name]; 

but I'm having errors !!

 

so how can I handle this ??

 

THANK YOU FOR YOUR TIME !

 

[watthehell]

Try running this code in PHP My Admin and see the result... how the fields are displayed then you can assign by no. i.e.

<?php 
echo $row[0];
echo $row[1];
?>

like this

[alex_funky_dj]

thanks a lot for ur fast reply, it works fine with numbers, but can't it be handled with names :$ !!

[watthehell]

Yes if you use names then there will be two results for $row['name'], so it will be hard to fetch the one you want, I guess there wont be problem with number though...

[alex_funky_dj]

Thanks a alot, that learned me to make the fields name more unique next time.

thanks again

 

-Mahmoud