1.創建數據表

CREATE TABLE category(
`cat_id` SMALLINT unsigned not null auto_increment comment '類別id',
`cat_name` VARCHAR(30) not null default '' comment '類別名稱',
`par_id` SMALLINT unsigned not null default 0 comment '類別父id',
PRIMARY KEY (`cat_id`)
)engine=myisam default charset=utf8;

?

2. 編寫一個函數,遞歸遍歷,實現無限分類

function tree($arr,$pid=0,$level=0)
{static $list = array();foreach ($arr as $v){//如果是父節點,則將其存到$list中//并以此節點作為根節點,遍歷其子節點if($v['par_id'] == $pid){$v['level'] = $level;$list[] = $v;tree($arr,$v['cat_id',$level+1);}}return $list;
}

?