help with a join and group

[scarhand]

theres gotta be a way so that this only uses 1 query....im assuming using a join and a group by

 

heres my current code:

 

$sql = mysql_query("select * from `databases` where `id` in (select `id_database` from `categories`)");

while ($row = mysql_fetch_assoc($sql))
{
echo $row['name'] . '<br />';

$sql_c = mysql_query("select * from `categories` where `id_database`='" . $row['id'] . "'");

while ($row_c = mysql_fetch_assoc($sql_c))
{
	echo $row_c['title'] . '<br />';
}
}

[fenway]

select * from `databases` inner join `categories` on `databases`.`id`= `categories`.`id_database`