Match 2 arays against each other

[vicodin]

Ok so this is what i need to do. I am programming a search engine for my site and pretty much this is how i think i should work but not quiet sure how to do it.

 

1.User Submits a query.(i can code this part)

2. If the query has a white space in it break it into an array. example query ="Playstation 3" It would put playstation and 3 in an array (i can code this part).

3.Go into my database and look at all the products keywords and but them in an array. (I can code this as well)

4.Check my first array against the db array and if they match then output the product stop checking this array against my first array and go the next products keywords until there is no more products. (This is what i dont know how to do. Pretty much the only thing i dont know how to do is the stuff in bold.)

 

Any help would be much appreciated.

 

Thanks all.

Your Friendly Neighborhood Narcotic - Vic.

[DarkerAngel]

<?php

 

mysql_query("SELECT * FROM products WHERE MATCH(keywords) AGAINST('$keyword') ORDER BY score DESC");

 

?>

 

Set your keywords to full text and give that a whirl

[vicodin]

I need to keep my keywords in my database to one cell and so they are separated by a |.

[DarkerAngel]

well with full text you can just have information in there like

 

 

"Playstation 3 PS3 Sony Play Station SixAxis"

 

and it will still return that result if I entered

 

"PS3 SixAxis" into a search string

[vicodin]

Really??? Wow didnt know that... Thanks