3 search fields Need to return results for multiple words for each feild NOT all feilds

Mar 16, 2012 2:17 AM

• 

  Currently Being Moderated

  15. Jonathan Fortis,

  

  Mar 26, 2012 4:20 PM   in reply to Jonathan Fortis

  Report

  mysql_select_db($database_hostprop, $hostprop);

  $query_Recordset1 = sprintf("SELECT tk_job_title, tk_job_location, tk_job_salary, LEFT(tk_job_desc,200) as truncated_job_desc FROM think_jobsearch WHERE tk_job_title LIKE %s OR tk_job_location LIKE %s OR tk_job_salary LIKE %s", GetSQLValueString("%" . $var_tk_job_title_Recordset1 . "%","text"),GetSQLValueString("%" . $var_tk_job_location_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_tk_job_salary_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);

   

  i added the "%" . to the beginning of the variable

   

  its working better but if i input security guard it returns nothing even if security guard cheif is present in the DB

   

  i take it this is because the wild card ar only on either end?

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  16. bregent,

  

  Mar 26, 2012 4:25 PM   in reply to Jonathan Fortis

  Report

  >its working better but if i input security guard it returns nothing even if security guard cheif is present in the DB

   

  >i take it this is because the wild card ar only on either end?

   

  No, it should work. Add an echo statement at the end of the code to output the $query_Recordset1 string and post the results.

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  17. Jonathan Fortis,

  

  Mar 26, 2012 4:42 PM   in reply to bregent

  Report

  ok where do i put the echo?

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  18. bregent,

  

  Mar 26, 2012 10:52 PM   in reply to Jonathan Fortis

  Report

  Put it anywhere after the code that you have posted. We need to examine the SQL string sent to the db.

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  19. Jonathan Fortis,

  

  Mar 27, 2012 1:28 AM   in reply to bregent

  Report

  >Put it anywhere after the code that you have posted.

   

  ok

   

  > We need to examine the SQL string sent to the db.

   

  what do i need to do for this?
  

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  20. bregent,

  

  Mar 27, 2012 10:28 AM   in reply to Jonathan Fortis

  Report

  >what do i need to do for this?

   

  You just need to add an echo statement so that the $query_Recordset1 string is output to the screen. Then paste the results into this thread.

    Submit

  |

  Mark as:
• 

  Currently Being Moderated

  21. Jonathan Fortis,

  

  Mar 27, 2012 11:06 AM   in reply to bregent

  Report

  i put an echo at the end

   

  think_jobsearch WHERE tk_job_title LIKE %s OR tk_job_location LIKE %s OR tk_job_salary LIKE %s", GetSQLValueString("%" . $var_tk_job_title_Recordset1 . "%","text"),GetSQLValueString("%" . $var_tk_job_location_Recordset1 . "%", "text"),GetSQLValueString("%" . $var_tk_job_salary_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;

  echo  $query_Recordset1

   

  and got the below results

   

  SELECT tk_job_title, tk_job_location, tk_job_salary, LEFT(tk_job_desc,200) as truncated_job_desc FROM think_jobsearch WHERE tk_job_title LIKE '%security%' OR tk_job_location LIKE '%Location%' OR tk_job_salary LIKE '%Salary%'

    Submit

  |

  Mark as: