/home/mip/public_html_/old_mip/admin/sqldelete.php
<?php
// Files for deleting a field.
session_start();
require_once("func_all.php");
$db = db_connect();
switch($what){
case "online_applicants" :
if($applicants){
foreach($applicants as $applicant_id){
$sql = "DELETE FROM personal_live WHERE applicant_id='$applicant_id'";
$result = mysql_query($sql);
echo mysql_error();
log_sql($sql);
$sql = "DELETE FROM training_live WHERE applicant_id='$applicant_id'";
$result = mysql_query($sql);
echo mysql_error();
log_sql($sql);
$sql = "DELETE FROM education_live WHERE applicant_id='$applicant_id'";
$result = mysql_query($sql);
echo mysql_error();
log_sql($sql);
$sql = "DELETE FROM employment_live WHERE applicant_id='$applicant_id'";
$result = mysql_query($sql);
echo mysql_error();
log_sql($sql);
}
}
header("Location: manage_online_applicants.php");
break;
case 'user': $sql = "DELETE FROM users WHERE user_id=$user_id";
$result = mysql_query($sql);
echo mysql_error();
if($result){
header("Location: manage_user.php");
}
break;
case 'webjob':
$sql = "DELETE FROM webjobs WHERE webjobid=$webjobid";
$result = mysql_query($sql);
echo mysql_error();
if($result){
header("Location: manage_jobs.php");
}
break;
case 'announcement':
$sql = "DELETE FROM announcement WHERE event_id=$event_id";
$result = mysql_query($sql);
echo mysql_error();
if($result){
header("Location: manage_announcement.php");
}
break;
}
?>
