Doing a recursive category system, Stuck..

[flamerail]

Ok, So heres the simple development code.

<select name="select">

	<?
	$query = mysqli_query(core_db(),"SELECT * FROM article_cat WHERE parent_id = '0'");
	while($cat = mysqli_fetch_array($query)){
	echo '<option value="'.$cat['id'].'">'.$cat['name'].'</option>';

	}
	?>
        </select>

 

article_cat is setup (ID | NAME | PARENT_ID) Essentially if the cat is parent_id 0 its the root level, and any sub level category sets parent_id as the category id before it, I have no Idea how to recursively loop this, Any ideas?

 

Thanks!

[aschk]

You have to LEFT JOIN the table to itself (however many times you want depth).

[flamerail]

I looked at some examples, Left Join is brutally slow and useless for what I need

[fenway]

I looked at some examples, Left Join is brutally slow and useless for what I need

Shouldn't be... post the EXPLAIN.