PHP and Multiple DB Selects

[twp]

I've got two tables from which I need to extract information, but the data from the second table depends on the information I get from the first one. Is there an easy way to handle this?\[code\]<?php mysql_connect('localhost', 'root', 'root') or die(mysql_error()); mysql_select_db('stadium') or die(mysql_error()); $result = mysql_query("SELECT * FROM events"); $result2 = mysql_query("SELECT name FROM competitions WHERE id='$row[competition_id]' "); while($row = mysql_fetch_array($result)) { echo "<tr id=\"" . $row['id'] . "\"> \n<td>" . $row['name'] . "</td>"; echo "<td>" . $row['competition_id'] . "</td>"; echo "<td>" . $row['date'] . "</td></tr>"; }?>\[/code\]