Multiple MySQL query???

[Anon]

Hello;
I know this is not the best Forum for this but you folks are so darn good.

I am trying to write a query that looks at 2 tables and gets certain info from one if a condition is met by the other.
Here is the code I am using.

SELECT name, id FROM category WHERE parent=5 AND FROM inventory WHERE Available=0 ORDER BY name

Both category and inventory are tables.
What am I doing wrong?

[Anon]

$sql = "SELECT category.name as catname, category.id as catid, inventory.name as invname, inventory.id as invid WHERE (category.parent = '5') AND (inventory.Available = '0')";

$result = mysql_query($sql, $db);

then you can access
while ($myrow = mysql_fetch_array($result)) {
$myrow["catid"] etc...
}

[Anon]

SELECT name, id FROM category,inventory WHERE category.parent=5
AND inventory.vailable=0 ORDER BY name