[SOLVED] Using info in one table to get info in another table - php/mysql

[dont_be_hasty]

Hi,

 

I need help writing a mysql statement. I have given an example of the tables below. On my webpage the user enters a term (which is in table 1), i basically need to get the id of this term, and use this to display the description from table 2 for this id.

 

Table 1: term(id, name, type, term)

Table 2: term_ref(term_id, description)

 

Here is the php code ive been using to display info from the same table:

 

$query1="SELECT name FROM term WHERE term = '$term1'";

$result1=mysql_query($query1) or die(mysql_error());       

$row1 = mysql_fetch_assoc($result1);

 

I need help change the sql statement so i can use two tables.

 

 

Thanks in advanced.

[revraz]

SELECT `description` FROM term_ref JOIN term ON (term_ref.term_id = term.id)

[dont_be_hasty]

Thanks, got the join to work.