I am trying to search for employees using key words i have entered in the database. and including a link to there resume in the result. only one of the links shows the proper result the rest of the links just duplicate this. I am not sure whehter i need to destroy the session in some way.
Form:
Search For Employee<br>
<input type='text' size='50' name='search'>
<input type="submit" name="submit" value="Search">
</center>
</font>
</form>
complexsearch.php
<?php //get data session_start(); $button = $_GET['submit']; $search = $_GET['search']; if (!$button) echo "YOU DIDNT SUBMIT A KEYWORD"; else { if (strlen($search)<=2) echo "SEARCH TERM TOO SHORT"; else { echo"You searched for $search"; //connect to database include("connect.php"); // a bit of filtering $search = strtoupper($search); $search= strip_tags($search); $search = trim ($search); $keywords = $getrow['preferedlocation']; //explode our search term $search_exploded = explode(" ",$search); foreach ($search_exploded as $search_each) { //construct query $x++; if ($x==1) $construct .= "preferedlocation LIKE '%$search_each%'"; else $construct .= " OR preferedlocation LIKE '%$search_each%'"; } //echo out construct $construct = "SELECT * FROM jobseekers WHERE $construct"; $run = mysql_query($construct); $foundnum = mysql_num_rows($run); if ($foundnum==0) echo "No results found."; else { echo "$foundnum results found!
";
while ($runrows = mysql_fetch_assoc($run))
{
$jobseekerid = $runrows['jobseekerid'];
$jobseekeremail = $runrows['jobseekeremail'];
$jobseekerpassword = $runrows['jobseekerpassword'];
$jobseekertitle = $runrows['jobseekertitle'];
$jobseekerfirstname = $runrows['jobseekerfirstname'];
$jobseekerlastname = $runrows['jobseekerlastname'];
$jobseekeraddress = $runrows['jobseekeraddress'];
$jobseekerphoneno = $runrows['jobseekerphoneno'];
$jobseekerdob = $runrows['jobseekerdob'];
$jobseekergender = $runrows['jobseekergender'];
$imagelocation = $runrows['imagelocation'];
$preferedlocation = $runrows['preferedlocation'];
$preferedcategory = $runrows['preferedcategory'];
$_SESSION['jobseekerid']= $jobseekerid;
echo "
$jobseekerid
$jobseekerfirstname $jobseekerlastname
$jobseekeremail
$jobseekeraddress
$jobseekerphoneno
Resume information
resumeviewer
<?php session_start(); $jobseekerid = $_SESSION['jobseekerid']; $connect = mysql_connect("localhost","root",""); mysql_select_db("jobmerger"); // sending query $result = mysql_query("SELECT * FROM resume WHERE jobseekerid = $jobseekerid"); if (!$result) { die("Query to show fields from table failed"); } while ($row = mysql_fetch_assoc($result)) { $employer_name_1a = $row['employer_name_1']; $employer_address_1a = $row['employer_address_1']; $job_1_datesa = $row['job_1_dates']; $job_1_titlea = $row['job_1_title']; $job_1_dutiesa = $row['job_1_duties']; $employer_name_2a = $row['employer_name_2']; $employer_address_2a = $row['employer_address_2']; $job_2_datesa = $row['job_2_dates']; $job_2_titlea = $row['job_2_title1']; $job_2_dutiesa = $row['job_2_duties']; $employer_name_3a = $row['employer_name_3']; $employer_address_3a = $row['employer_address_3']; $job_3_datesa = $row['job_3_dates']; $job_3_titlea = $row['job_3_title']; $job_3_dutiesa = $row['job_3_duties']; $employer_name_4a = $row['employer_name_4']; $employer_address_4a = $row['employer_address_4']; $job_4_datesa = $row['job_4_dates']; $job_4_titlea = $row['job_4_title']; $job_4_dutiesa = $row['job_4_duties']; $skillsa = $row['skills']; $native_languagea = $row['native_language']; $language_1a = $row['language_1']; $language_1_levela = $row['language_1_level']; $language_2a = $row['language_2']; $language_2_levela = $row['language_2_level']; $language_3a = $row['language_3']; $language_3_levela = $row['language_3_level']; $education_levela = $row['education_level']; $school_1_namea = $row['school_1_name']; $school_1_coursesa = $row['school_1_courses']; $school_1_datesa = $row['school_1_dates']; $school_1_degreea = $row['school_1_degree']; $school_2_namea = $row['school_2_name']; $school_2_coursesa = $row['school_2_courses']; $school_2_datesa = $row['school_2_dates']; $school_2_degreea = $row['school_2_degree']; $school_3_namea = $row['school_3_name']; $school_3_coursesa = $row['school_3_courses']; $school_3_datesa = $row['school_3_dates']; $school_3_degreea= $row['school_3_degree']; } mysql_free_result($result); ?>