OK I managed to set up full text searching using MATCH in the MySQL queries
Just a quick question. I have 2 text fields to search from so I have used AND command in the MySQL query. Both text fields need to completed to accomplish the search.
What I would like to be able to do is:
If text_field_1 is only filled in, but not text_field_2 it will search.
If text_field_2 is only filled, but not text_field_1 it will still search
If text field 1 and text field 2 are both filled in, it will search.
Do I need to create an if statement to check whichtext fields are filled in and assign it's own MySQL query or can I do something with the MySQL query that allows to search AND OR
Hope this makes some sort of sense.
