require_once("../resources/dbconnect.php"); $Action1 = $HTTP_POST_VARS['Action1']; if ($Action1== "RemoveResume"){ $SQL1 = "delete from seekereducation where skid = ".$skid; mysql_query($SQL1) or die("delete from seekereducation failed"); $SQL2 = "delete from seekercertificationstates where skid = ".$skid; mysql_query($SQL2) or die("delete from seekercertificationstates failed"); $SQL3 = "delete from endorsementsubcategory where skid = " . $skid; mysql_query($SQL3) or die("delete from endorsementsubcategory failed"); $SQL4 = "delete from careerexperience where skid = " . $skid; mysql_query($SQL4) or die("delete from careerexperience failed"); $SQL5 = "delete from otherexperience where skid = " . $skid; mysql_query($SQL5) or die("delete from otherexperience failed"); $SQL6 = "delete from seekerreferences where skid = " . $skid; mysql_query($SQL6) or die("delete from seekerreferences failed"); $SQL7 = "delete from seekerdocscurrent where skid = " . $skid; mysql_query($SQL7) or die("delete from seekerdocscurrent failed"); $SQL8 = "delete from seekerinterviewanswers where skid = " . $skid; mysql_query($SQL8) or die("delete from seekerinterviewanswers failed"); $SQL9 = "delete from seekerstate where skid = " . $skid; mysql_query($SQL9) or die("delete from seekerstate failed"); $SQL10 = "delete from seekersubcategory where skid = " . $skid; mysql_query($SQL10) or die("delete from seekersubcategory failed"); $SQL11 = "delete from seekerterm where skid = " . $skid; mysql_query($SQL11) or die("delete from seekerterm failed"); $SQL12 = "delete from savedresumes where skid = " . $skid; mysql_query($SQL12) or die("delete from savedresumes failed"); $SQL13 = "delete from jobsapplied where skid = " . $skid; mysql_query($SQL13) or die("delete from jobsapplied failed"); $SQL14 = "delete from jobseeker where id = " . $skid; mysql_query($SQL14) or die("delete from jobseeker failed"); header("location:../logout.php"); } if ($Action1== "RemoveCoverLetter"){ $dateUpdated = date("Y-m-d"); $SQL = "update jobseeker set coverletter = '' , lastupdated = '$dateUpdated' " ; $SQL .= " where id = " . $skid; mysql_query($SQL) or die("updating jobseeker failed"); ?> } if ($Action1== "RemoveInterview"){ $SQL6 = "delete from seekerinterviewanswers where skid = $skid "; mysql_query($SQL6) or die("delete failed"); $dateUpdated = date("Y-m-d"); $SQL2 = "update jobseeker set lastupdated = '$dateUpdated' where id = $skid "; mysql_query($SQL2) or die("update jobseeker failed"); ?> } ?>