復制代碼 代碼如下:

CREATE TABLE `type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fid` int(11) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
)

復制代碼 代碼如下:

INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '0', '手機');
INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '0', '電腦');
INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '0', '鞋子');
INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '0', '衣服');

復制代碼 代碼如下:

INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '2', '臺式'), (NULL, '2', '筆記本');

復制代碼 代碼如下:

INSERT INTO `type` (`id`, `fid`, `name`) VALUES (NULL, '6', 'ausu'), (NULL, '6', 'hp');

復制代碼 代碼如下:

DELETE FROM `type` WHERE `id`=6

復制代碼 代碼如下:

function del($fid) {
$sql="SELECT * FROM `type` WHERE `fid`=$fid";
$rs=mysql_query($sql);

for ($i = 0; $i < count($rs); $i++) {
$sql="DELETE FROM `type` WHERE `id`={$rs[$i]['id']}";
mysql_query($sql);

del($rs['id']);//遞歸
}
}
del(6);//執行操作

復制代碼 代碼如下:

DELETE FROM `type` WHERE `fid`=6

復制代碼 代碼如下:

SELECT * FROM `type` WHERE `fid`=2

復制代碼 代碼如下:

function sel($fid) {
$sql="SELECT * FROM `type` WHERE `fid`=$fid";
$rs=mysql_query($sql);

for ($i = 0; $i < count($rs); $i++) {
echo $rs[$i]['name'];

sel($rs[$i]['id']);//遞歸
}
}
sel(2);

復制代碼 代碼如下:

SELECT * FROM `goods` WHERE `tid`=2