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

$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?

[Lionel]

I am going a bit insane here. Look at the first 2 categories, then look at the duplicates for sports

if ($_REQUEST['do']=='main')
{

$getcats=$db->query_read("SELECT * from " . TABLE_PREFIX . "ypcats
ORDER BY category ASC");
$rcount=1;
$rpertr= $vbulletin->options['ypmaincolumns'];
$rrows = $db->num_rows($getcats);
while ($mycats=$db->fetch_array($getcats))
{
if($mycats['parent']=='0'){
$catmain=$mycats['category'];
$catid=$mycats['id'];
if($mycats['catimage']!='')
{
$catimage="<img style=\"padding-right:4px;\" align=\"left\" border=\"0\" alt=\"".$catmain."\"
src=\"images/yellowpages/caticons/".$mycats['catimage']."\" />";
} else {
$catimage="";
}
}
//#################################
$subcats=null;
$getsubcats=$db->query_read("SELECT * from " . TABLE_PREFIX . "ypcats where parent=$catid
ORDER BY category ASC");

while ($getsub=$db->fetch_array($getsubcats))
{
if($getsub['parent'] >='0'){
$mysubcats=$getsub['category'];
$mysubid=$getsub['id'];
}
eval('$subcats .= "' . fetch_template('haitiwebs_yellowpagessubcats') . '";');
}

eval('$html .= "' . fetch_template('haitiwebs_yellowpagesmain') . '";');

if ($rcount == $rpertr && $rcount != $rrows)
$rcount = 0;
$rcount++;
} while ($rcount != 1 && $rcount > $rpertr)
{
eval('$html .= "' . fetch_template('haitiwebs_yellowpagesmain') . '";');
$rcount++;
}

[Lionel]

phew!!! I think I got it! Freakin loop!!