"); } $row=mysql_fetch_array($result); //--------------------cv------------------ $sql="SELECT * FROM cvprogress WHERE cid='$visitor'"; $result=mysql_query($sql); if (!$result){ echo("

Error performing query : ". mysql_error()."

"); } $progress=mysql_fetch_array($result); if (($progress["details"]==1)&&($progress["education"]==1)&&($progress["summary"]==1)) { $cvpresent='Yes'; } else { $cvpresent='No'; } //--------------------job------------------- if (($project==1) && ($apply==1)) { $query="SELECT * FROM projects where jobref='$jobref'"; $ret=mysql_query($query); $jobinfo=mysql_fetch_array($ret); $vacancy=$jobinfo["project"]; }elseif ($apply==1){ $query="SELECT * FROM jobpostings where jobref='$jobref'"; $ret=mysql_query($query); $jobinfo=mysql_fetch_array($ret); $vacancy=$jobinfo["jobtitle"]; } //--------------------activity----------------------- $sql="SELECT * FROM applicants WHERE cid='$visitor'"; $result=mysql_query($sql); $numjobapps=mysql_num_rows($result); //--------------------storedsearch----------------------- $sql="SELECT * FROM storedsearch WHERE cid='$visitor'"; $result=mysql_query($sql); $numsearches=mysql_num_rows($result); //--------------------headhunt profile---------------- $sql="SELECT * FROM headhunt WHERE cid='$visitor'"; $result=mysql_query($sql); $ishunt=mysql_num_rows($result); if ($ishunt==1) { $hunt='Yes'; } else { $hunt='No'; } //--------------------headhunts----------------------- $sql="SELECT * FROM headhunts WHERE cid='$visitor'"; $result=mysql_query($sql); $numheadhunts=mysql_num_rows($result); include("/home/hiring_template/include/header.tpl"); ?>

myHiring Welcome ".capitalise($row["firstname"])." "); $name=$row["firstname"]; if ($newexec==1) { echo("Congratulations! You have been accepted into the executive centre. You have been emailed a new password. This will replace your current password for logging in to $sitename in future. "); }elseif ($execfailed==1){ echo("You did not qualify for the executive centre. "); } if ($apply==1) { echo("Your application has been forwarded and you should receive a confirmation email shortly. "); } ?> "); } ?> Title Status Action Profile Active View | Edit Uploaded CV Yes View (Allow 30secs) | No Update"); } ?> Online CV View"); } elseif ($cvpresent=='No') { echo(" Create"); } ?> Applications View searchAgents View Be Headhunted View Being Headhunted? View Clipboard "); $screenqs=0; for ($i=0; $i < count($joblist); $i++) { $jobref=$joblist[$i]; if ($jobref>0) { $clipsql="SELECT jobtitle FROM jobpostings WHERE jobref='$jobref'"; $clipres=mysql_query($clipsql); $clipjobs=mysql_fetch_array($clipres); echo("".$clipjobs["jobtitle"]." "); } } echo("View | Apply   executiveCentre Listed below are some of the areas planned for the executiveCentre.   Executive Jobs Resource Centre Key Contacts "); } else { echo("  executiveCentre Qualify for membership today & gain access to Senior Executive Job Opportunities."); } ?>