=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!='' && $keyword!='Enter Keywords'){$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); $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"); if($zip_coordinates[lattitude]!=''){$site_lat=$zip_coordinates[lattitude];} if($zip_coordinates[longitude]!=''){$site_long=$zip_coordinates[longitude];} $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"); if($page<$max_pages){$next=$page+1; $next=" Next";} if($page>1){$prev=$page-1; $prev="Prev ";} } $ip = getenv("REMOTE_ADDR"); $insert="INSERT INTO search (ip, ad, publication, expiry, distance) values('$ip', '$s4[ad]', '$s4[publication]', '$s4[expiry]', '')"; $previous="$s4[ad]"; $previous2="$s6[ad]"; while($s5=mysql_fetch_row($s5a)){ if($previous!=$s5[0] && $previous2!=$s5[0] && $s5[0]!=''){$insert.=", ('$ip', '$s5[0]', '$s5[1]', '$s5[2]', '')";} $previous=$s5[0]; } mysql_free_result($s5a); while($s7=mysql_fetch_row($s7a)){ if($previous!=$s7[0] && $previous2!=$s7[0] && $s7[0]!=''){$insert.=", ('$ip', '$s7[0]', '', '$s7[2]', '".round($s7[3])."')"; } $previous="$s7[0]"; } mysql_free_result($s7a); mysql_query($insert); if($page>=1){$page=$page;} else{$page=1;} $start=$page*25-25; $search=mysql_query("SELECT ad FROM search WHERE ip='$ip' && 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' 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]="See more ".strtolower($s[city])." jobs";} 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]="See more ".strtolower($s1[3])." jobs";} 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]="See more ".strtolower($s3[3])." jobs";} 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]="See more ".strtolower($s4[city])." jobs";} 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]="See more ".strtolower($s4[city])." jobs";} 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:
Province/State:
Metropolitan Area:
City Name:
OR
$zip_postal Code:
Search Within:
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("
"); $email=mysql_real_escape_string($email); $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"); ?>