[Resolved] can't seem create a good search engine for my site

[airric]

my site uses a mysql db. Ican search the word bad and it comes up every title with the letters bad in any of the titles. but I search bad boys (whichis a title) it comes up empty???

I think I might start completely over with the search engine do have any recommendations??

[Roger_Ramjet]

What kind of search are you doing? A query with LIKE '%bad%' would return everything with the letters 'bad' in it., so I assume that is what you currently have.

From the sounds of it you need to be doing a full text search . You will have to change the minimum word legnth if you want to search for 3 letter words. Read the fine tuning section

[airric]

Yes that is corect. like is the seach code I am using. Ok will do thanks.

[airric]

Ramjet,

I keep trying to convert this:
"WHERE ". $dvd_search_type . " LIKE\"%" . $dvd_search . "%\" ";

to

"WHERE MATCH (". $dvd_search_type . ") AGAINST (" . $dvd_search . ")";

but i can't get it work withour erroring.

Any Ideas?

[Roger_Ramjet]

So post the errors and echo the query string and post that as well.

[airric]

Thanks for checking this out for me! I'm not getting an Error per say it just does post anything

<select name="dvd_search_type" size="1">

<option <? if ($dvd_search_type == $dvd_field[2][6]) {echo "selected ";} echo "value=\"" . $dvd_field[2][6] . "\">" . $dvd_field[1][6] . "</option>"; ?>

</select>

<input type="text" size="15" maxlength="45" name="dvd_search" value="<? echo $dvd_search; ?>">

if ($dvd_search != "") {
$dvd_search_string1 = "WHERE MATCH (". $dvd_search_type . ") AGAINST (" . $dvd_search . ") ";}

$dvd_query_string = "SELECT " . $dvd_field[2][1] . "," . $dvd_field[2][4] . "," . $dvd_field[2][5] . ", " . $dvd_field[2][6] . ", " . $dvd_field[2][8] . ", " . $dvd_field[2][11] . ", " . $dvd_field[2][13] . ", " . $dvd_field[2][14] . ", " . $dvd_field[2][17] . ", " . $dvd_field[2][21] . ", " . $dvd_field[2][24] . "," . $dvd_field[2][25] . ", " . $dvd_field[2][33] . ", " . $dvd_field[2][34] . ", " . $dvd_field[2][35] . ", " . $dvd_field[2][36] . "," . $dvd_field[2][37] . ", " . $dvd_field[2][38] . ", " . $dvd_field[2][39] . ", " . $dvd_field[2][45] . ", " . $dvd_field[2][46] . ", " . $dvd_field[2][47] . " FROM " . $dvd_search_db . " " . $dvd_search_string1 . " ORDER by " . $dvd_sort_string . $dvd_limit_string;

$dvd_result = @mysql_db_query($dvd_mysql_db, $dvd_query_string);

then it fetch_arrays the result

Thank You