session_start(); header("Cache-control: private"); // IE 6 Fix. if (isset($_SESSION["cfgfile"])) { include("/home/config/".$_SESSION["cfgfile"]); } else { echo("No config file"); exit(); } include("/home/hiring_template/include/header.tpl"); include("/home/config/common.php"); //connect to the mysql server $dbcnx = dbconn( $host, $user, $pass, $dbname); //insert search $sql="SELECT * FROM candaccount WHERE cid='$visitor'"; $result=mysql_query($sql); if (!$result){ echo("
Error performing query : ". mysql_error()."
"); } $row=mysql_fetch_array($result); $email=$row["email"]; if ($addsummary) { $summary=nl2br($summary); $sql="INSERT INTO headhunt SET ". "cid='$visitor',". "email='$email',". "prefjobtitle='$prefjobtitle',". "availability='$availability',". "summary='$summary',". "experience='$experience',". "date=curdate()"; if (!mysql_query($sql)){ echo("
Error performing query : ". mysql_error()."
"); } } if ($edit==1) { $sql="UPDATE headhunt SET ". "prefjobtitle='$prefjobtitle',". "availability='$availability',". "summary='$summary',". "experience='$experience',". "date=curdate() WHERE cid='$visitor'"; if (!mysql_query($sql)){ echo("
Error performing query : ". mysql_error()."
"); } } if ($delete==1) { $sql="DELETE FROM headhunt WHERE cid='$visitor'"; mysql_query($sql); } $q="SELECT * FROM headhunt WHERE cid='$visitor'"; $result=mysql_query($q); if (!$result){ echo("
Error performing query : ". mysql_error()."
"); } $num=mysql_num_rows($result); $row=mysql_fetch_array($result); $row["experience"]=translate_experience($row["experience"]); ?>
| ||||||||||||||||||||