1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
function supprimer($id) { $conn = db_connect();
$sql = "select children from header where postid = $id";
$res = mysql_query($sql, $conn);
$row = mysql_fetch_assoc($res);
$children = $row['children'];
if ($children != 0) {
$sql = "delete from header where parent = $id";
supprimer($children);
mysql_query($sql, $conn);
}
$sql = "delete from header where postid = $id";
mysql_query($sql, $conn);
};
$id = $_GET['postid'];
$conn = db_connect();
//On dit au parent qu'il vient de perdre son fils
$sql = "select parent from header where postid = $id";
$res = mysql_query($sql, $conn);
$row = mysql_fetch_assoc($res);
$parent = $row['parent'];
$sql = "update header set children = 0 where postid = $parent";
mysql_query($sql);
//On supprime le header et sa descendance
supprimer($id); |
Partager