Closed

Modify php script for search results

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')";

}

Skills: MySQL, PHP

See more: i.t. job search, search match, modify something, search results php, php script sql, mysql_num_rows, php script searches, sql select script, php script search database, mysql boolean, need search results, mysql boolean search, question answer database, answer questions php mysql, match results, smarter script, count mysql, mysql word count, database php script, word count php, question answer php mysql, php mysql count, sql search result result, select count php, search script php sql

About the Employer:
( 4 reviews ) Spokane, United States

Project ID: #4502646

25 freelancers are bidding on average $77 for this job

siddhu1986

Hi, experienced Web Developer. Kindly check PMB for more info. Regards

$34 USD in 0 days
(107 Reviews)
6.4
ansi2

Ready to start! Thanks, 2ansi

$50 USD in 1 day
(85 Reviews)
6.2
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below [url removed, login to view] More

$309 USD in 5 days
(85 Reviews)
6.1
farhaoui

HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!

$33 USD in 1 day
(41 Reviews)
4.8
gopasoft

Love your project and would like to start ASAP. Many thanks.

$55 USD in 2 days
(30 Reviews)
4.7
kirilpanchev

Professional freelancer here with 10+ years of experience in Web Development including PHP, MySQL, etc. I am a Zend Certified PHP Developer (ZCE). Cheers!

$45 USD in 1 day
(30 Reviews)
4.7
aukint

What you want more to modify, you mean advance search option or what please clarify the point.

$155 USD in 3 days
(22 Reviews)
4.6
ViDeDe

I can do it. Provide ftp credential, please

$34 USD in 1 day
(17 Reviews)
4.5
html5css3php5

Hi i help you get correct results while search.. already i did nice search query..

$34 USD in 0 days
(23 Reviews)
4.3
evidcomm

Ready to start now..Many thanks..

$63 USD in 1 day
(14 Reviews)
4.1
Mohsen6558

I can make better and faster result for your search. ready to start.

$54 USD in 3 days
(10 Reviews)
4.0
pranotosh

I'm a Web-Developer and i can provide you better search way. Please consider my bid and send details. Thanks

$50 USD in 3 days
(16 Reviews)
4.0
rjsultan

Ready to fix it right now

$35 USD in 3 days
(12 Reviews)
3.9
Razaali75

hi i am ready lets start

$55 USD in 3 days
(16 Reviews)
3.9
ForeignTree

Can do it right now. Lets start and finish

$30 USD in 1 day
(6 Reviews)
3.7
quicksol22

I can do this right now.

$35 USD in 1 day
(5 Reviews)
3.7
linuxien2011

Hi I'm ready to do it. Best Regards

$35 USD in 1 day
(3 Reviews)
3.0
voinescualex

Hello, i can do this quickly.

$45 USD in 3 days
(2 Reviews)
2.8
pfHollyville

Based on the script extract that you provided I think it should be fairly straight forward. The code uses BOOLEAN MODE rather than NATURAL LANGUAGE MODE. Should be simple to change the mode and test it against some s More

$30 USD in 1 day
(4 Reviews)
2.6
ady7zu

Let's finish this project!

$35 USD in 1 day
(1 Review)
2.3