need help in getting category ids of all the multi level subcat

[syedirtaza]

i have a mysql table which is

categoryid
categoryname
parentid

now the senario is that i want to grab all categoryid of a parentid ...

like

if i put parent id = 12

so that parent id has now become root id and it should get all the sub sub categories of that parent id ... thanks for ur help in advance

[syedirtaza]

found the solution here nice site

1.
function showlist($parent, &$catlistids="") {
2.
$result = mysql_query("SELECT ID FROM categorie WHERE sublevelID='$parent'");
3.
while ($line = mysql_fetch_array($result)) {
4.
if($catlistids!=""){ $catlistids .= ", "; }
5.
$catlistids .= $line["ID"];
6.
showlist($line["ID"], &$catlistids);
7.
}
8.
return $catlistids;
9.
}