Using Joins - Why Aren't Them Working?

See this post for background info & to see the other things I tried:

http://forums.devshed.com/showthread.php?p=691829

----------------------------------------

I'm not sure how well I can explain this without writing a novel.

I want to get all of the subcategories for a given category and list them.

I have 2 tables for this, one is categories and one is subcategories:

categories table:

---------------------------
catid | title | descript |
---------------------------
1 | Forms | find forms |
---------------------------
2 | Legal | legal forms|
---------------------------
3 | Tax | tax forms |
---------------------------


subcategories table:

-----------------
catid | parent |
-----------------
2 | 1 |
-----------------
3 | 1 |
-----------------

I want to now select all of the subcategories for the Forms category. But this snippet of code below returns the parent row instead of the subcategories.



PHP Code:





 $query = "SELECT * FROM categories c LEFT JOIN
 subcategories sc ON c.catid = sc.parent WHERE c.catid = 1";

$catarray = mysql_query($query,$connect); 







The code above returns:

1 | Forms | find forms |

When I want it to return:

2 | Legal | legal forms|
---------------------------
3 | Tax | tax forms |