also i tried using the xxxxx as the defualt value instead of the SQL wildcard % and no results are displayed??

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 5;

$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {

  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$var_SalaryReq_Recordset1 = "xxxxx";

if (isset($_GET['SalaryReq'])) {

  $var_SalaryReq_Recordset1 = $_GET['SalaryReq'];

}

$var_skills_offered_Recordset1 = "xxxxx";

if (isset($_GET['skills_offered'])) {

  $var_skills_offered_Recordset1 = $_GET['skills_offered'];

}

$var_location_Recordset1 = "xxxxx";

if (isset($_GET['location'])) {

  $var_location_Recordset1 = $_GET['location'];

}

$var_PositionReq_Recordset1 = "xxxxx";

if (isset($_GET['PositionReg'])) {

  $var_PositionReq_Recordset1 = $_GET['PositionReg'];

}

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = sprintf("SELECT SalaryReq, skills_offered, location, PositionReq, otherComments, userid, FirstName, Surname FROM think_signup WHERE SalaryReq LIKE %s OR PositionReq LIKE %s OR location LIKE %s OR skills_offered LIKE %s", GetSQLValueString("%" . $var_SalaryReq_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_skills_offered_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_location_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_PositionReq_Recordset1 . "%", "text"));

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {

  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

  $all_Recordset1 = mysql_query($query_Recordset1);

  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";

if (!empty($_SERVER['QUERY_STRING'])) {

  $params = explode("&", $_SERVER['QUERY_STRING']);

  $newParams = array();

  foreach ($params as $param) {

    if (stristr($param, "pageNum_Recordset1") == false &&

        stristr($param, "totalRows_Recordset1") == false) {

      array_push($newParams, $param);

    }

  }

  if (count($newParams) != 0) {

    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));

  }

}

$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);

the form is

            <input name="PositionReq" type="text" class="textfeilds" value="Job Title" size="32" />

            <input name="skills_offered" type="text" class="textfeilds" value="Skills Required" size="32" />

            <input name="SalaryReq" type="text" class="textfeilds" value="Salary Offered" size="32" />

            <input name="location" type="text" class="textfeilds" value="Location" size="32" />

examples of search criteria are job title would be say police officer, location would be say london

when using xxxx no results are being dispalyed

<form id="form3" name="form3" method="post" action="../candidate-search-results.php">

          <p>

            <input name="PositionReq" type="text" class="textfeilds" value="Job Title" size="32" />

            <input name="skills_offered" type="text" class="textfeilds" value="Skills Required" size="32" />

            <input name="SalaryReq" type="text" class="textfeilds" value="Salary Offered" size="32" />

            <input name="location" type="text" class="textfeilds" value="Location" size="32" />

<td colspan="2"><img name="CANDSEARCH_r1_c1_s1" src="../images/CANDSEARCH_r1_c1_s1.png" width="74" height="5" border="0" id="CANDSEARCH_r1_c1_s1" alt="" /></td>

              <td rowspan="3"><a href="../candidate-search-results.php" onmouseout="MM_nbGroup('out');" onmouseover="MM_nbGroup('over','CANDSEARCH_r1_c3_s1','images/CANDSEAR CH_r1_c3_s2.png','images/CANDSEARCH_r1_c3_s4.png',1);" onclick="MM_nbGroup('down','navbar1','CANDSEARCH_r1_c3_s1','images/CA NDSEARCH_r1_c3_s3.png',1);">

                <input type="image" src="../images/CANDSEARCH_r1_c3_s1.png" width="50" height="17" border="0" id="CANDSEARCH_r1_c3_s1" alt="" />

        </form>

Is the above what u needed, I re

moved the other button link but that di

dnt do anything

OK,i see that when i posted to the thread, i have now changed the form to GET but it is still not working, if i change the default value to the wildcard % it displays all the results but if i change it to xxxxx i get no results, so i know the way the form was sent was incorrect but now being changed i am still getting the same results.

i put an echo at the end of the script, i then done a search on the location and the echo gave the following resutls

SELECT SalaryReq, skills_offered, location, PositionReq, otherComments, userid, FirstName, Surname FROM think_signup WHERE SalaryReq LIKE '%%%' OR PositionReq LIKE '%%%' OR location LIKE '%%%' OR skills_offered LIKE '%%%'

i have added the submit value as below

<input type="image" src="../images/CANDSEARCH_r1_c3_s1.png" width="50" height="17" border="0" value="Submit" id="CANDSEARCH_r1_c3_s1" alt="" />

and still showing the same as before

>Why are you populating a value in the text field? How are you clearning that out before submitting?

this is to show the user what to input, i am not clearing it before submission (this is the same as the other search that working)

sorry i was trying something i have changed the values back and done another echo test

SELECT SalaryReq, skills_offered, location, PositionReq, otherComments, userid, FirstName, Surname FROM think_signup WHERE SalaryReq LIKE '%xxxxx%' OR PositionReq LIKE '%xxxxx%' OR location LIKE '%xxxxx%' OR skills_offered LIKE '%xxxxx%'

http://www.rerecruitment.co.uk/beta/candidate-search-results.php

it isnt passing any of the information

the other search that is working is giving the following results

current-positions.php?tk_job_title=security&tk_job_location=Location&t k_job_salary=Salary&x=87&y=5

again here is the echo

SELECT SalaryReq, skills_offered, location, PositionReq, otherComments, userid, FirstName, Surname FROM think_signup WHERE SalaryReq LIKE '%xxxxx%' OR PositionReq LIKE '%xxxxx%' OR location LIKE '%xxxxx%' OR skills_offered LIKE '%xxxxx%'

<form id="form3" name="form3" method="get" action="../candidate-search-results.php">

its strange becuase some of the feilds are working the job title isnt working and neither is the skills required but the salary offered and location are working now

it looks like all the inputs field are getting muddled up.

Hello, i am testing the search code

$var_SalaryReq_Recordset1 = "xxxxx";

if (isset($_GET['SalaryReq'])) {

  $var_SalaryReq_Recordset1 = $_GET['SalaryReq'];

}

$var_skills_offered_Recordset1 = "xxxxx";

if (isset($_GET['skills_offered'])) {

  $var_skills_offered_Recordset1 = $_GET['skills_offered'];

}

$var_location_Recordset1 = "xxxxx";

if (isset($_GET['location'])) {

  $var_location_Recordset1 = $_GET['location'];

}

$var_PositionReq_Recordset1 = "xxxxx";

if (isset($_GET['PositionReq'])) {

  $var_PositionReq_Recordset1 = $_GET['PositionReq'];

}

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = sprintf("SELECT userid, FirstName, Surname, SalaryReq, PositionReq, location, otherComments, skills_offered FROM think_signup WHERE SalaryReq LIKE %s OR PositionReq LIKE %s OR location LIKE %s OR skills_offered LIKE %s", GetSQLValueString("%" . $var_SalaryReq_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_PositionReq_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_location_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_skills_offered_Recordset1, "text"));

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

in the database i have in the skills_offered column

good communicator excellent negotiator truck driver

when i search good communicator i get nothing, when i search excellent negotiator i get nothing, when i search truck driver i get tthe result. i have tried various combinations like good driver and i get nothing

can anyone help?

sorry,,,just needed a kick  . "%"

thanks for the prompt.

regards