Closed

Modify php script for search results

This project received 27 bids from talented freelancers with an average bid price of $74 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
27
Project Description

I have a php script that searches my database. I need it modified so that it does a better job at searching for results. Right now if it has one extra word it doesn't find anything. I need something that searches smarter.

This is what I currently have

$sql = "select * from questions where (Question LIKE '%$quest_search%' OR Answer LIKE '%$quest_search%') AND (active='yes')";
$result = mysql_query ($sql);
$count = mysql_num_rows( $result );

if($count == "0"){
$sql = "SELECT * FROM questions WHERE MATCH(Question,Answer) AGAINST ('$quest_search' IN BOOLEAN MODE) AND (active='yes')";

}

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online