I'm trying to make a search engine for mySQL and I need help figuring out how to parse several words from a text box into search strings so I can search for more things.
(eg. I want to look for anything containing "microsoft, starcraft, and halflife")
I can get my form to work with just one argument, or a string that appears together in the database (eg. starcraft broodwars), but I don't know how to put serarate words into separate variables.
Also, in the SELECT statement, how can I get it to understand that it needs to ignore NULL variables (eg. if I want to take only 3 words instead of 4 words sometime).
Thanks in advance for the help
DrMarvin
