=3){ if($form=='complete'){ if($page>0){$page=$page-1;} $start=$page*25; if($keyword!=''){$s_keyword="&& resume like'%$keyword%'";} if($country!='' or $province!='All' or $metro!='' or $city!=''){ if($country!='All Countries' && $country!=''){$s_country="&& country='$country'";} if($province!='All' && $province!=''){$s_province="&& province='$province'";} if($metro!=''){$s_metro="&& metro='$metro'";} if($city!=''){$s_city="&& city='$city'";} } elseif($zip!=''){ $zip=str_replace(" ", "", $zip); $zip=strtoupper($zip); $zip_length=strlen($zip); if($zip_length>=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($category!='All Categories'){ $s_category1="&& category1='$category'"; $s_category2="or email!='' $s_keyword $s_country $s_province $s_metro $s_city $zip_variable && category2='$category'"; $s_category3="or email!='' $s_keyword $s_country $s_province $s_metro $s_city $zip_variable && category3='$category'"; } $page_variable="keyword=$keyword&category=$category&province=$province&metro=$metro&city=$city&country=$country&distance=$distance&form=complete&zip=$zip"; if(!$page){$page=0;} $resume=mysql_query("SELECT * FROM resumes WHERE email!='' $s_keyword $s_country $s_category1 $s_province $s_metro $s_city $zip_variable $s_category2 $s_category3 ORDER BY title"); $num_rows=mysql_num_rows($resume); $resume=mysql_query("SELECT * FROM resumes WHERE email!='' $s_keyword $s_country $s_category1 $s_province $s_metro $s_city $zip_variable $s_category2 $s_category3 ORDER BY title LIMIT $start, 25"); $resume=mysql_fetch_assoc($resume); if($resume[email]!=''){ $max_pages=($num_rows/25)+.5; $first=($page*25)+1; $last=($page*25)+25; $page=$page+1; if($num_rows<$last){$last=$num_rows;} if($page<$max_pages){$next=$page+1; $next=" Next";} if($page>1){$prev=$page-1; $prev="Prev ";} print(""); if($resume[file]!=''){$link="$resume[file]";} else{$link="resumeview.php?resume=$resume[title]&username=$resume[email]";} $resume[title]=str_replace("`", "'", $resume[title]); $resume[title]=str_replace("~", """, $resume[title]); print(" "); $resume1a=mysql_query("SELECT name, city, province, country, metro, category1, category2, category3, keywords, file, title, email FROM resumes WHERE email!='' $s_keyword $s_country $s_category1 $s_province $s_metro $s_city $zip_variable $s_category2 $s_category3 ORDER BY title LIMIT $start, 25"); $resume1=mysql_fetch_row($resume1a); while($resume1=mysql_fetch_row($resume1a)){ if($resume1[9]!=''){$link="$resume1[9]";} else{$link="resumeview.php?resume=$resume1[10]&username=$resume1[11]";} print(""); } print("
$first - $last of $num_rows resumes "); $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
$resume[name]
$resume[title]
Email This Job Seeker
$resume[city], $resume[province], $resume[country] ($resume[metro]) $resume[category1]
$resume[category2]
$resume[category3]

$resume[keywords]
VIEW RESUME
$resume1[0]
$resume1[10]
Email This Job Seeker
$resume1[1], $resume1[2], $resume1[3] ($resume1[4]) $resume1[5]
$resume1[6]
$resume1[7]

$resume1[8]
VIEW RESUME
"); print("
$first - $last of $num_rows resumes "); $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
"); } else{ print("
No Results Found
There are no resumes that match your search. Please try broadening your search.

Click Here to search again.
"); } } else{ print("
Search Through Resumes
1 Keyword:
Enter a keyword or phrase that appears in Job Seekers keywords list.
2 Select resumes from up to 3 categories.
Category1: "); include("categories.php"); print("
3
Country:
Province/State:
Metropolitan Area:
City Name:
OR
Zip/Postal Code:
Search Within:
4
"); } } else{ print("
Unauthorized Access
You do not have authorization to search for resumes. To gain access, you must be an employer and have granted access. Please contact our sales force to inquire about enabling resume searching.

Sales
$sales_phone
"); } include("bottom.php"); ?>