21,886
社区成员
发帖
与我相关
我的任务
分享
mysql_connect();
mysql_select_db('test');
$sql =<<< SQL
CREATE TABLE category (
id INT AUTO_INCREMENT PRIMARY KEY,
lft INT NOT NULL,
rgt INT NOT NULL
);
SQL;
//mysql_query($sql);
$sql =<<< SQL
INSERT INTO category
VALUES(1,1,12),
(6,2,5),
(17,3,4),
(5,6,11),
(16,7,8),
(15,9,10),
(8,25,26),
(7,27,28),
(4,29,30),
(3,31,32);
SQL;
//mysql_query($sql);$rs = mysql_query("SELECT * FROM category ORDER BY lft");
$st = array();while($row = mysql_fetch_assoc($rs)) {
while ( $st && $row ['lft'] > $st [0] [1] ) {
array_shift ( $st );
echo "</ol></li>\n";
}
$n = ($row ['rgt'] - $row ['lft'] - 1) / 2;
echo "<li>$row[id] [$row[lft],$row[rgt]]";
if ($n) {
array_unshift ( $st, array (
$row ['lft'],
$row ['rgt']
) );
echo "<ol>\n";
} else
echo "</li>\n";
}