query("SELECT UserID,CONCAT(Lname, ' ',Fname) as 'Name' FROM user where isactive = 0 order by UserID ASC"); echo ''; } function activate_user() { global $con; echo '



'; $post = $_POST; unset($post['Enable']); foreach($post as $key => $value) { if($key == "Users"){ $userids = $value; } } $elemente = sizeof($userids); for($x=0;$x<$elemente;$x++){ $result = $con->query("UPDATE user SET isactive='1' WHERE UserID='{$userids[$x]}';") or die(mysql_error()); } header('Location: '.$_SERVER['REQUEST_URI']); } function delete_account() { global $con; echo '



'; $post = $_POST; unset($post['Enable']); foreach($post as $key => $value) { if($key == "Users"){ $userids = $value; } } $elemente = sizeof($userids); for($x=0;$x<$elemente;$x++){ $result = $con->query("delete from user WHERE UserID='{$userids[$x]}';") or die(mysql_error()); } header('Location: '.$_SERVER['REQUEST_URI']); } if(isset($_POST['Enable'])){ activate_user(); } if(isset($_POST['Delete'])){ delete_account(); } ?>