"; $get_cats = sql_query(" select * from $tb_categories where PID='$PID' order by Category asc "); while($get_rows = sql_fetch_array($get_cats)){ $cc++; $cell_color = "#eeeeee"; $cc % 2 ? 0 : $cell_color = "#dddddd"; echo ""; $count_sites = sql_query(" select count(*) as count from $tb_links where Category='$get_rows[ID]' "); $count_array = sql_fetch_array($count_sites); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $get_sub_cats = sql_query(" select * from $tb_categories where PID='$get_rows[ID]' order by Category asc "); while($get_sub_rows = sql_fetch_array($get_sub_cats)){ $cc++; $cell_color = "#eeeeee"; $cc % 2 ? 0 : $cell_color = "#dddddd"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $get_sub2_cats = sql_query(" select * from $tb_categories where PID='$get_sub_rows[ID]' order by Category asc "); while($get_sub2_rows = sql_fetch_array($get_sub2_cats)){ $cc++; $cell_color = "#eeeeee"; $cc % 2 ? 0 : $cell_color = "#dddddd"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } } ?>

Top "; unset($gcid); if(isset($PID)){ $gcid = $PID; } while($gcid > 0){ $mlc_query = sql_query(" select * from $tb_categories where ID = '$gcid' "); $mlc_array = sql_fetch_array($mlc_query); $cat_array[] = $mlc_array[Category]; $pid_array[] = $mlc_array[ID]; $gcid = $mlc_array[PID]; } $count = sizeof($pid_array); for($depth=$count;$depth>=0;$depth--){ if($pid_array[$depth]){ if($PID == $pid_array[$depth]){ $html .= ">> "; $html .= ereg_replace("_"," ",($cat_array[$depth])); $html .= "  "; } else { $html .= ">> "; $html .= ereg_replace("_"," ",($cat_array[$depth])); $html .= "  "; } } } echo $html; unset($html); ?> [ Insert Top Level Categories ] [ Insert Children Categories ]
Categories	Allow Sites	Show Count	# of Sites	Child Type	Child Count	Edit Cats	Related Cats	Insert Child	Delete Cats
"; echo eregi_replace("_"," ",$get_rows["Category"]) . "	" . $get_rows["AllowSites"] . "	" . $get_rows["ShowSiteCount"] . "	" . $count_array["count"] . "	" . $get_rows["Children"] . "	" . $get_rows["TopChildren"] . "	Edit	Related	Insert	Delete
"; for($i=0;$i<1;$i++){ echo $pixel; } $count_sites = sql_query(" select count(*) as count from $tb_links where Category='$get_sub_rows[ID]' "); $count_array = sql_fetch_array($count_sites); echo ""; echo eregi_replace("_"," ",$get_sub_rows["Category"]) . "	" . $get_sub_rows["AllowSites"] . "	" . $get_sub_rows["ShowSiteCount"] . "	" . $count_array["count"] . "	" . $get_sub_rows["Children"] . "	" . $get_sub_rows["TopChildren"] . "	Edit	Related	Insert	Delete
"; for($i=0;$i<2;$i++){ echo $pixel; } $count_sites = sql_query(" select count(*) as count from $tb_links where Category='$get_sub2_rows[ID]' "); $count_array = sql_fetch_array($count_sites); echo "" . eregi_replace("_"," ",$get_sub2_rows["Category"]); echo "	"; echo $get_sub2_rows["AllowSites"] . "	" . $get_sub_rows["ShowSiteCount"] . "	" . $count_array["count"] . "	" . $get_sub2_rows["Children"]; echo "	" . $get_sub2_rows["TopChildren"]; echo "	"; echo "Edit	"; echo "Related	Insert	Delete
[ Insert Top Level Categories ] [ Insert Children Categories ]