The job was deleted successfully."; } else { $qm = "select * from job_post where ename = \"$ename\" order by job_id"; $rqm = mysql_query($qm) or die(mysql_error()); echo "

Your current job offers:

"; while($aqm = mysql_fetch_array($rqm)) { $day = date(d); $month = date(m); $year = date(Y); $EXdate = "$aqm[EXyear]"."-"."$aqm[EXmonth]"."-"."$aqm[EXday]"; $dnes = "$year"."-"."$month"."-"."$day"; $qd = "select to_days('$EXdate') - to_days('$dnes')"; $rqd = mysql_query($qd) or die(mysql_error()); $adate = mysql_fetch_array($rqd); $qempl = "select CompanyName, CompanyInstallation, CompanyCity from job_employer_info where ename = \"$ename\" "; $rempl = mysql_query($qempl) or die(mysql_error()); $ae = mysql_fetch_array($rempl); if($aqm[j_target] == '1') { $clname = 'Student (High School)'; } elseif($aqm[j_target] == '2') { $clname = 'Student (Undergraduate/Graduate)'; } elseif($aqm[j_target] == '3') { $clname = 'Entry Level (less than 2 years of experience)'; } elseif($aqm[j_target] == '4') { $clname = 'Mid Career (2+ years of experience)'; } elseif($aqm[j_target] == '5') { $clname = 'Management (Manager/Director of Staff)'; } elseif($aqm[j_target] == '6') { $clname = 'Executive (SVP, EVP, VP)'; } elseif($aqm[j_target] == '7') { $clname = 'Senior Executive (President, CEO)'; } $FormattedJobCat= str_replace(",", ", ", $aqm[JobCategory]); echo "

Job ID: $aqm[job_id] Position: $aqm[position] Description: " . nl2br($aqm[description]) . " Salary: $" . sprintf("%0.2f",$aqm[salary]) . "/ $aqm[s_period] Salary (upper limit): $". sprintf("%0.2f",$aqm[salary2]) . "/ $aqm[s_period] Job Category: $FormattedJobCat Target: $clname The job expires after: $adate[0] day(s) Installation: $aqm[installation] City: $aqm[city] State: $aqm[state] view Applicants list for this position

delete

edit

---

"; } } ?>