=6){$zip=substr($zip, 0, 3)." ".substr($zip, 3);} $pos1=strpos("$zip", '00'); $pos2=strpos("$zip", '0'); if($pos1 === false){} elseif($pos1!== false){if($pos1==0){$zip=substr($zip, 1);}} if($pos2=== false){} elseif($pos2!== false){if($pos2==0){$zip=substr($zip, 1);}} if($distance!='within any distance'){ $zip_coordinates=mysql_query("SELECT lattitude, longitude FROM zip_code WHERE zip_code='$zip'"); $zip_coordinates=mysql_fetch_assoc($zip_coordinates); $lat_up=($distance/100)+$zip_coordinates[lattitude]; $lat_down=$zip_coordinates[lattitude]-($distance/100); $long_up=($distance/100)+$zip_coordinates[longitude]; $long_down=$zip_coordinates[longitude]-($distance/100); $zip_variable="&& latitude<$lat_up && latitude>$lat_down && longitude<$long_up && longitude>$long_down"; } } else{ if(!$country){$s_country="";} elseif($country!='All Countries'){$s_country="&& country='$country'";} if(!$province){$s_province="";} elseif($province!='All'){$s_province="&& province='$province'";} if($metro!=''){$s_metro="&& metro='$metro'";} if($city!=''){$s_city="&& city='$city'";} } if($keyword!=''){$s_keyword1="&& description like'%$keyword%'"; $s_keyword2="job_title like'%$keyword%'"; $s_keyword3="company like'%$keyword%'"; $keyword1="$s_keyword1 or $s_keyword2 && spotlight!='1' && publication='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro or $s_keyword3 && spotlight!='1' && publication='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro"; $keyword2="$s_keyword1 or $s_keyword2 && spotlight!='1' && publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro or $s_keyword3 && spotlight!='1' && publication='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro"; } $page_variable="category=$category&country=$country&province=$province&city=$city&metro=$metro&distance=$distance&form=complete&keyword=$keyword&zip=$zip"; if(!$page){$page=1;} if($company!=''){ $page_variable=$page_variable."&company=$company"; if($location_us=="" && $location_ca=="selected"){$order=" ORDER BY country, ad";} else{$order=" ORDER BY country, ad desc";} $s=mysql_query("SELECT * FROM jobs WHERE spotlight='1' && expiry>='$time' && publication='$publication' && company='$company' $order"); $s=mysql_fetch_assoc($s); $s1a=mysql_query("SELECT ad, job_title, company, city, province, country, hourly_wage, logo FROM jobs WHERE spotlight='1' && expiry>='$time' && publication='$publication' && expiry>='$time' && company='$company' $order"); $s1=mysql_fetch_row($s1a); $s2=mysql_query("SELECT * FROM jobs WHERE spotlight='1' && publication!='$publication' && expiry>='$time' && company='$company' $order"); $s2=mysql_fetch_assoc($s2); $s3a=mysql_query("SELECT ad, job_title, company, city, province, country, hourly_wage, logo FROM jobs WHERE spotlight='1' && publication!='$publication' && expiry>='$time' && company='$company' $order"); $s3=mysql_fetch_row($s3a); $s4=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE spotlight!='1' && publication='$publication' && expiry>='$time' && company='$company' $order"); $s4=mysql_fetch_assoc($s4); $s5a=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE spotlight!='1' && publication='$publication' && expiry>='$time' && company='$company' $order"); $s5=mysql_fetch_row($s5a); $s6=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE spotlight!='1' && publication!='$publication' && expiry>='$time' && company='$company' $order"); $s6=mysql_fetch_assoc($s6); $s7a=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE publication!='$publication' && expiry>='$time' && company='$company' $order"); $s7=mysql_fetch_row($s7a); $profile=mysql_query("SELECT profile, company FROM accounts WHERE company='$s1[company]'"); $profile=mysql_fetch_assoc($profile); if($page<$max_pages){$next=$page+1; $next=" Next";} if($page>1){$prev=$page-1; $prev="Prev ";} } else{ $s=mysql_query("SELECT * FROM jobs WHERE spotlight='1' && expiry>='$time' && publication='$publication' $s_category $s_city $s_province $s_country $zip_variable $s_metro"); $s=mysql_fetch_assoc($s); $s1a=mysql_query("SELECT ad, job_title, company, city, province, country, hourly_wage, logo FROM jobs WHERE spotlight='1' && expiry>='$time' && publication='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro"); $s1=mysql_fetch_row($s1a); $s2=mysql_query("SELECT * FROM jobs WHERE spotlight='1' && publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro LIMIT 0,0"); $s2=mysql_fetch_assoc($s2); $s3a=mysql_query("SELECT ad, job_title, company, city, province, country, hourly_wage, logo FROM jobs WHERE spotlight='1' && publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro LIMIT 0,0"); $s3=mysql_fetch_row($s3a); $s4=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE spotlight!='1' && publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro $keyword1 ORDER BY ad"); $s4=mysql_fetch_assoc($s4); $s5a=mysql_query("SELECT ad, publication, expiry FROM jobs WHERE spotlight!='1' && publication='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro $keyword1 ORDER BY ad"); $s5=mysql_fetch_row($s5a); if($zip_coordinates[lattitude]!=''){$site_lat=$zip_coordinates[lattitude];} if($zip_coordinates[longitude]!=''){$site_long=$zip_coordinates[longitude];} $s6=mysql_query("SELECT ad, publication, expiry, (SQRT(POW(($site_long-longitude),2)+POW(($site_lat-latitude),2))) as distance FROM jobs WHERE publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro $keyword2 ORDER BY distance, ad"); $s6=mysql_fetch_assoc($s6); $s7a=mysql_query("SELECT ad, publication, expiry, (SQRT(POW(($site_long-longitude),2)+POW(($site_lat-latitude),2))) as distance FROM jobs WHERE publication!='$publication' && expiry>='$time' $s_category $s_city $s_province $s_country $zip_variable $s_metro $keyword2 ORDER BY distance, ad"); $s7=mysql_fetch_row($s7a); if($page<$max_pages){$next=$page+1; $next=" Next";} if($page>1){$prev=$page-1; $prev="Prev ";} } $ip = getenv("REMOTE_ADDR"); $insert=mysql_query("INSERT INTO search (ip, ad, publication, expiry) values('$ip', '$s4[ad]', '$s4[publication]', '$s4[expiry]')"); $insert=mysql_query("INSERT INTO search (ip, ad, publication, expiry) values('$ip', '$s6[ad]', '', '$s6[expiry]')"); $previous="$s4[ad]"; $previous2="$s6[ad]"; while($s5=mysql_fetch_row($s5a)){ if($previous!="$s5[0]" && $previous2!="$s5[0]"){$insert=mysql_query("INSERT INTO search (ip, ad, publication, expiry) values('$ip', '$s5[0]', '$s5[1]', '$s5[2]')");} $previous="$s5[0]"; } while($s7=mysql_fetch_row($s7a)){ if($previous!="$s7[0]" && $previous2!="$s7[0]"){$insert=mysql_query("INSERT INTO search (ip, ad, publication, expiry, distance) values('$ip', '$s7[0]', '', '$s7[2]', '".round($s7[3])."')"); } $previous="$s7[0]"; } $delete_blank=mysql_query("DELETE FROM search WHERE ip='$ip' && ad=''"); if($page>=1){$page=$page;} else{$page=1;} $start=$page*25-25; $search=mysql_query("SELECT ad FROM search WHERE ip='$ip' && ad!='' GROUP BY ad"); $total_jobs=mysql_num_rows($search); $search=mysql_fetch_assoc($search); $max_pages=($total_jobs/25)+.49; $max_pages=round($max_pages, 0); $first=($page*25)-24; $last=($page*25); if($total_jobs<$last){$last=$total_jobs;} $search1=mysql_query("SELECT ad FROM search WHERE ip='$ip' order by publication desc, distance, expiry desc LIMIT $start, 25"); $search1=mysql_fetch_assoc($search1); $search2a=mysql_query("SELECT ad FROM search WHERE ip='$ip' GROUP BY ad order by publication desc, distance, expiry desc LIMIT $start, 25"); $search2=mysql_fetch_assoc($search2a); $delete=mysql_query("DELETE FROM search WHERE ip='$ip'"); if($profile[profile]!=''){ $profile[profile]=str_replace("=~", "src='", $profile[profile]); $profile[profile]=str_replace("=`", "src='", $profile[profile]); $profile[profile]=str_replace("~>", "'>", $profile[profile]); $profile[profile]=str_replace("`>", "'>", $profile[profile]); $profile[profile]=str_replace("`", "'", $profile[profile]); $profile[profile]=str_replace("~", """, $profile[profile]); print("

$profile[company]

$profile[profile]

"); } if($s[logo]!=''){$s[logo]="";} else{$s[logo]="";} if($s[job_title]!='' or $s2[job_title]!=''){ print(""); } if($s[job_title]!=''){ print(""); } while($s1=mysql_fetch_row($s1a)){ if($s1[7]!=''){$s1[7]="";} else{$s1[7]="";} print(""); } if($s2[job_title]!=''){ if($s2[logo]!=''){$s2[logo]="";} else{$s2[logo]="";} print(""); } while($s3=mysql_fetch_row($s3a)){ if($previous_ad!="$s3[0]"){ if($s3[7]!=''){$s3[7]="";} else{$s3[7]="";} print(""); } $previous_ad="$s3[0]"; } $first1=$first-1; if($search1[ad]!=''){ $s4=mysql_query("SELECT * FROM jobs WHERE ad='$search1[ad]'"); $s4=mysql_fetch_assoc($s4); if($s4[hourly_wage]>0){$s4[hourly_wage]="
$$s4[hourly_wage]/hr";} else{$s4[hourly_wage]="";} if($s4[job_title]!=''){ print("

Spotlight Jobs
$s[job_title] View Job Listing | Email To Friend	$s[company] ".ucwords(strtolower($s[city])).", $s[province], $s[country]	$s[logo]
$s1[1] View Job Listing | Email To Friend	$s1[2] ".ucwords(strtolower($s1[3])).", $s1[4], $s1[5]	$s1[7]
$s2[job_title] View Job Listing | Email To Friend	$s2[company] ".ucwords(strtolower($s2[city])).", $s2[province], $s2[country]	$s2[logo]
$s3[1] View Job Listing | Email To Friend	$s3[2] ".ucwords(strtolower($s3[3])).", $s3[4], $s3[5] $s3[6]	$s3[7]

"); } if($s4[ad]==''){ print("

$first - $last of $total_jobs jobs that match your search criteria "); } $loop=2; if($page>=6){$page1=$page-5; print("First ");}else{$page1=1;} print("$prev$page1 "); $loop=1; while($loop<10 && $page1<$max_pages){ $page1=$page1+1; print("$page1 "); $loop++; } print("$next

"); } elseif($s4[ad]!=''){ if($s4[logo]!=''){$s4[logo]="";} else{$s4[logo]=""; $s4[company]='';} print(""); $previous_ad="$s4[ad]"; } $result_row=1; while($search2=mysql_fetch_row($search2a)){ $s4=mysql_query("SELECT * FROM jobs WHERE ad='$search2[0]'"); $s4=mysql_fetch_assoc($s4); if($s4[job_title]!='' && $previous_ad!="$s4[ad]"){ if($s4[logo]!=''){$s4[logo]="";} else{$s4[logo]=""; $s4[company]='';} print(""); } } $max_pages1=round($max_pages, 0); print("

No Job Listings
There are currently no job listings that match your criteria. Click Here to try another search.
$s4[job_title] View Job Listing | Email To Friend	$s4[company] ".ucwords(strtolower($s4[city])).", $s4[province], $s4[country]	$s4[logo]
$s4[job_title] View Job Listing | Email To Friend	$s4[company] ".ucwords(strtolower($s4[city])).", $s4[province], $s4[country]	$s4[logo]
You are currently viewing page $page of $max_pages1 "); $loop=0; if($page>=6){$page1=$page-7; print("First ");}else{$page1=0;} print("$prev"); while($loop<10 && $page1<$max_pages){ $page1=$page1+1; if($page1>0){ print("$page1 "); $loop++; } } print("$next

"); $delete=mysql_query("DELETE FROM search WHERE ip='$ip'"); } else{ print("

"); print(""); if($location_ca=='selected'){$zip_postal="Postal/Zip";} else{$zip_postal="Zip/Postal";} print(" Find Your Next Career 1 Keywords: Job Title | Company Name | Location | Keyword Category: "); include("categories.php");print(" 2 Country: All Countries Canada Only USA Only Province/State: AllABBCMBNBNL NTNSNUONPEQC SKYT-- ALAKASAZAR CACOCTDEDCFM FLGAGUHIIDIL INIAKSKYLAME MHMDMAMIMNMS MOMTNENVNHNJ NMNYNCNDMPOH OKORPWPAPRRI SCSDTNTXUTVT VIVAWAWVWIWY Metropolitan Area: City Name: OR $zip_postal Code: Search Within: within any distance within 5 Km (3 miles) within 10 Km (6 miles) within 25 Km (15 miles) within 50 Km (30 miles) within 75 Km (46 miles) within 100 Km (60 miles) within 150 Km (90 miles) within 200 Km (120 miles) within 300 Km (180 miles) 3 "); print("

"); print(" Job Alert Select your alert criteria and let $title notify you weekly. You'll receive an email every sunday that includes a list of jobs that fit your criteria. Click Here to create a Job Alert. "); print(" Saved Searches "); while($searches2=mysql_fetch_row($searches2a)){ print(""); } } elseif($email!=''){print("You have not saved any searches.");} else{print("You must be a member and be logged in to begin saving searches.");} print(" "); $searches1=mysql_query("SELECT * FROM my_searches WHERE email='$email' ORDER BY id"); $searches1=mysql_fetch_assoc($searches1); $searches2a=mysql_query("SELECT * FROM my_searches WHERE email='$email' ORDER BY id"); $searches2=mysql_fetch_row($searches2a); if($searches1[name]!=''){ print("$searches1[name] SEARCH DELETE $searches2[2] SEARCH DELETE "); print("

"); } } include("bottom.php"); ?>