[RESOLVED] [HELP] connecting to 2 tables

[kender]

i am attempting to get arrays from 2 tables, actualy get an array from 1 table (done) and convert its output into data from another table

here is where i am currently

$get_name = mysql_query("select id, cat_title from categories") or die(mysql_error());
$cat_name = mysql_fetch_array($get_name);
if ( $cats[cat_id] == $cat_name[id] ) 
	{ 
	$cat_desc = $cat_name[cat_title]; 
	}

THIS returns all the same info for all instances

what i am trying to do

i have a list of category ID's 1, 2, 3, 4, 5... so on in my first table
i can pull that info fine, and print it

i have a list of category names that associate with those id's in a seperate table

so 1 = shoes 2 = blue 3 = sky.. so on

i am trying to get the php necessary to pull the names from the table, and replace the array of #'s with a new array of names

any help would be appreciated

thanks

[bastien]

make it easy on yourself and join the tables

select table1.field1, table1.fieldn, table2, field2, table3.fieldn
from
table1, table2
where
table1.field1=table2.field1
[and other where conditions]

the = fields in the where clause need to be the same where one is the foreign key on the other table...

[kender]

changed it to this

$get_name = mysql_query("
	select categories.id, categories.cat_title, list.cat_id 
	from categories, list 
	where list.cat_id=categories.id") or die(mysql_error());
$cat_name = mysql_fetch_array($get_name);

$cat_desc = $cat_name[categories.cat_title];

and returns now blank spaces in the result, instead of all = 1 thing, or the first working and the rest being the # still

[kender]

resolved

all i needed to do was sleep on it

and add the part in red
[FONT=times new roman]
$get_name = mysql_query("select id, cat_title from categories") or die(mysql_error());
while ($cat_name = mysql_fetch_array($get_name))
if ( $cats[cat_id] == $cat_name[id] )
{
$cat_desc = $cat_name[cat_title];
} [/FONT]