Help with Merging 2 queries into 1

[ciber]

Hi,

 

I have 2 tables, I am currently trying to get my query to get information from the one given information of the other:

 

I am inputting a slug value for the categories database, in which I am wanting the database to return values from the games database. I am currently able to do this in 2 queries, but want to reduce it. This is how my two queries work.

 

$result = mysql_query("SELECT * FROM categories WHERE slug = '$directory[1]' ") or die (mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$cid = $row['id'];
}

Then the second query

$result = mysql_query("SELECT * FROM games WHERE cat = '$cid' ") or die (mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
// Information is outputted
}

Does anyone know how I can get this information using one query?

[jskywalker]

SELECT g.*, c.* FROM games g
INNER JOIN categories c ON c.id = g.cat
WHERE c.slug = $directory;

[ciber]

Thanks so much, worked perfect!!