function del_kinds($root) { //刪除底下分類 $query3 = "select * from pro_kind where root=" . $root; $result3 = mysql_query($query3); while ($row3 = mysql_fetch_array($result3)) { del_kinds($row3["num"]); //刪除底下分類 del_products($row3["num"]); } $sql = "delete from pro_kind where root=" . $root; $query = mysql_query($sql) or die("無法刪除" . mysql_error()); }
$sql .= " where `num`=" . $_GET["num"]; $query = mysql_query($sql) or die("無法修改" . mysql_error()); ?> <script type="text/JavaScript"> alert('修改成功!'); window.location="kind.php?m=<?php echo $_GET["m"]; ?> "; </script> <?php exit; } else { if ($_GET["todo"] == "del") { //刪除 del_kinds($_GET["num"]); //刪掉底下商品分類 del_products($_GET["num"]); //刪除商品 $sql = "delete from " . $sqlname . " where num=" . $_GET["num"]; //刪掉項目 $query = mysql_query($sql) or die("無法刪除" . mysql_error()); ?> <script type="text/JavaScript"> window.location="kind.php?m=<?php echo $_GET["m"]; ?> "; </script> <?php exit;