[perleo]

I my DB i have a table called books and I want a search it for keywords.

If a user puts in a word I want php to seacrh the columns 'title' and 'comments' for that word, then give me a percentage for each result

Is there anyone free ones out there or can someone give me the code on how to do it.

Cheers

[NeverMind]

use LIKE in your SQL query to do this..

PHP Code:

//assuming this is the keyword..

$term = trim($_POST['term']);



$fetch = mysql_query("SELECT * FROM books WHERE title LIKE '%$term%' OR comments LIKE '%$term%'")or

die(mysql_error());



//complete the process here.. 

[perleo]

Originally Posted by NeverMind

use LIKE in your SQL query to do this..

PHP Code:

//assuming this is the keyword..

$term = trim($_POST['term']);



$fetch = mysql_query("SELECT * FROM books WHERE title LIKE '%$term%' OR comments LIKE '%$term%'")or

die(mysql_error());



//complete the process here.. 

So how do I get a percentage score for each result ?

[NeverMind]

So how do I get a percentage score for each result ?

don't know what exactly you mean by that !

[perleo]

well, on some sites you can get maby 10 results, and get a percentage of which was closest to your query.