how to display only 2nd level categories?

vzhen

Here is my code,
i set a 'display' column in my category table whether it display or not.

lets say, i have
A
-A.1
B
-B.1

and i only want to display A.1 and B.1. when i set A and B to display N.
my category list display nothing.

Any idea?

function current_categories($m,$id){
	$cat_array=array();
	$sql = "select * from `category`";
	$query = DB::Query($sql);
		while($row = DB::fetch_array($query)){
			$cat_array[] = array($row['id'],$row['name'],$row['pid'],$row['sort'],$row['display']);
		}
	$n = str_pad('',$m,'-',STR_PAD_LEFT);
	$n = str_replace("-","&nbsp;&nbsp;&nbsp;&nbsp;",$n);
	for($i=0;$i<count($cat_array);$i++){
		if($cat_array[$i][2]==$id && $cat_array[$i][4] == 'Y'){
		echo "<li>"."<a href=\"/team/index.php?gid=".$cat_array[$i][0]."\">".$cat_array[$i][1]."</a></li>";	
	current_categories($m+2,$cat_array[$i][0]);
		}
	}
}

Judgey

I'm sorry can you expand on this, I don't get it... Are A.1 and B.1 both sub catagories of A and B?

vzhen

Thank for you reply.

Yes, A.1 and B.2 are sub-cat of A and B

I dont wanna display the 1st level cat in my list. Only those sub-cat but i have no idea how to do this

Judgey

How are you connecting the catagory and sub catagory rows in the database?