Tag Archives: 无限分类

一句sql语句完成无限分类

– 表的结构 `cate` CREATE TABLE IF NOT EXISTS `cate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `pid` int(11) NOT NULL, `path` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

Posted in PHP | Tagged | Leave a comment