window.location='admin_adduser.php';";
}
}
else if($_GET["scholarships_id"]){
$strSQL = "DELETE FROM scholarships_history WHERE scholarships_id = '".$_GET["scholarships_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["loan_id"]){
$strSQL = "DELETE FROM loan_history WHERE loan_id = '".$_GET["loan_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["brethren_study_id"]){
$strSQL = "DELETE FROM brethren_study WHERE brethren_study_id = '".$_GET["brethren_study_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["brethren_work_id"]){
$strSQL = "DELETE FROM brethren_work WHERE brethren_work_id = '".$_GET["brethren_work_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["time_id"]){
$strSQL = "DELETE FROM time_set WHERE time_id = '".$_GET["time_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["news_id"]){
$strSQL = "DELETE FROM news WHERE news_id = '".$_GET["news_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "ลบขู้อมูลเรียบร้อยแล้ว";
}
}
else if($_GET["problem_id"]){
$strSQL = "DELETE FROM problem WHERE problem_id = '".$_GET["problem_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "ลบขู้อมูลเรียบร้อยแล้ว";
}
}
else if($_GET["reply_id"]&&$_GET["problem_id_reply"]){
$problem_id=$_GET["problem_id_reply"];
$strSQL = "DELETE FROM problem_reply WHERE reply_id = '".$_GET["reply_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["a_id"]){
$strSQL = "DELETE FROM oct WHERE a_id = '".$_GET["a_id"]."'";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "";
}
}
else if($_GET["process"] =='Set'){
$strTime = "SELECT * FROM time_set WHERE time_id = (SELECT MAX(time_id) FROM time_set)";
$objQueryTime = mysql_query($strTime) or die ("Error Query [".$strTime."]");
$objResultTime = mysql_fetch_array($objQueryTime);
$nisit_id_card = $_GET["nisit_id_card"];
//$strSQL = "UPDATE nisit SET nisit_status='1' where nisit_id_card = $nisit_id_card";
$strSQL = "UPDATE member_user SET mem_data='0' where mem_idcard = '$nisit_id_card'";
$objQuery = mysql_query($strSQL);
$strSQL2 = "UPDATE nisit SET nisit_yearloan='".$objResultTime['nisit_yearloan']."',nisit_status = '1' where nisit_id_card = '$nisit_id_card'";
$objQuery2 = mysql_query($strSQL2);
echo "";
//echo $nisit_id_card."weqweqweqw";
}
else if($_GET["process"] =='del'){
$nisit_id_card = $_GET["nisit_id_card"];
//$strSQL = "UPDATE nisit SET nisit_status='1' where nisit_id_card = $nisit_id_card";
//$strSQL = "DELETE FROM nisit WHERE nisit_id_card = '$nisit_id_card'";
// $objQuery = mysql_query($strSQL);
echo "";
//echo $nisit_id_card."weqweqweqw";
}else if($_GET["alert"] == "del"){
$strDEL = "DELETE FROM alert WHERE 1";
$objQueryDEL = mysql_db_query($dbname,$strDEL);
if($objQueryDEL){
echo "";
}
}
mysql_close();
?>