Category Tree

[Lionel]

I have this table with the following structure.

id
category
catimage
catimagebig
parent
description

I am trying to get it to display like

Category
parent1, parent2, parent3

I tried many combinations and I am not simply able to achieve it. The latest I have is all messed up

PHP Code:

$getcats=$db->query_read("SELECT  * from " . TABLE_PREFIX . "table where parent='0'
ORDER BY category ASC");
while ($cats=$db->fetch_array($getcats))
{
$catmain=$cats['category'];
$catid=$cats['id'];
if($cats['catimage']!='')
{
$catimage="<img style=\"padding-right:4px;\" align=\"left\" border=\"0\" alt=\"$catmain\" src=\"images/caticons/".$cats['catimage']."\" />";
} else {
$catimage="";
$allcats[]=$getcats['id'];
}
 
foreach($allcats as $allcat){
$sublimit=$vbulletin->options['ypsublimit'];
 
$getsubcats=$db->query_read("SELECT  * from " . TABLE_PREFIX . "table where parent > 0 ORDER BY category ASC LIMIT $sublimit");
while ($subcat=$db->fetch_array($getsubcats))
{
$mysubcats=$subcat['category'];
eval('$subcats .= "' . fetch_template('pagessubcats') . '";');
}
}
eval('$html .= "' . fetch_template('pagesmain') . '";');
} 


Please what am I doing wrong?