include("top.php");
if($user[email]!=''){
$page_variable="category=$category&country=$country&province=$province&city=$city&metro=$metro&distance=$distance&form=complete&keyword=$keyword&zip=$zip";
$hits=mysql_query("UPDATE jobs SET views=views+1 WHERE ad='$ad'");
$hit=mysql_query("INSERT INTO views(job_id, date, ip_address, publication) values('$ad', '".time()."', '".$_SERVER['REMOTE_ADDR']."', '$publication')");
$company=mysql_query("SELECT * FROM accounts WHERE company='$job[company]'");
$company=mysql_fetch_assoc($company);
$job[description]=str_replace("=~", "src='", $job[description]);
$job[description]=str_replace("=`", "src='", $job[description]);
$job[description]=str_replace("~>", "'>", $job[description]);
$job[description]=str_replace("`>", "'>", $job[description]);
$job[description]=str_replace("`", "'", $job[description]);
$job[description]=str_replace("~", """, $job[description]);
$job_keyword_start=strpos("$job[description]", "");
$job_keyword_end=strpos("$job[description]", "");
if($job_keyword_end>0){$job_keyword_end=$job_keyword_end+11;}
$job1[description]=substr("$job[description]", 0, $start);
$job2[description]=substr("$job[description]", $job_keyword_end);
$job[description]="$job1[description]"."$job2[description]";
$job[company]=str_replace("`", "'", $job[company]);
$job[company]=str_replace("~", """, $job[company]);
if($job[profile]=='0'){$company[profile]="";}
else{$profile=mysql_query("SELECT profile FROM accounts WHERE email='$job[email]'"); $profile=mysql_fetch_assoc($profile); $company[profile]="$profile[profile]";}
if($job[logo]==""){$company[logo]="";}
else{$company[logo]="";}
if($job[phone]>0){$job[phone]="(".substr($job[phone], 0, 3).")".substr($job[phone], 3, 3)."-".substr($job[phone], 6, 4)." ext".substr($job[phone], 10);}else{$job[phone]="";}
if($job[fax]>0){$job[fax]="(".substr($job[fax], 0, 3).")".substr($job[fax], 3, 3)."-".substr($job[fax], 6, 4)." ext".substr($job[fax], 10);}else{$job[fax]="";}
print("
");
}
include("bottom.php");
?>