I did look at the files, but I don't think I am that good with reading code of that size. That and I am unsure what errors to look for as well as what it is that you are trying to do.
When I say match exactly what I mean is will 'abc' match 'Abc' or ' abc' or 'I know my abcs'?
If you want to combine columns in a table you could do something like:
You can also join and compare the data from the tables using a Join statement, although I must say that I have never had much need to use them, so my knowledge of inner joins and LEFT or RIGHT outer joins is very little. You can read up a bit more about it here: http://dev.mysql.com/doc/refman/5.0/en/join.html
SELECT premise, summary, conclusion FROM review WHERE concat(premise, conclusion) like '%must%' and concat(premise,summary,conclusion) like '%storyline%'
When you say 6 terms to be searched one at a time or two at a time, etc, do you mean that you want to search the contents of a table and retrieve the results if all of the terms are located in the table and then search the next table using the same method?
What is the makeup of the columns in the tables? Integer, text, etc.
Sorry, I don't promise to be very helpful since my knowledge of MySQL is very limited, but your poblem has me a bit curious.