Hi, i've trying to put together a search engine and i've looked through the forum but haven't been able to find something similar to my own. Here's my problem, I have a MySQL database. The search I want is related to a single table with about 30 different fields. What I allow people to do is to select any where from 1 to 30 search options via drop down menu's then i'll search the database for matches.
Currently, i'm using a whole disgusting load of LIKE matches in my query for each of the 30 fields. Is there a better way to do this. What I thought about doing was to mash all of the data in the 30 fields into one freakin' huge string then use a string search function for each of the 30 options but that seemed just as retarded to me.
Any ideas?
Thanks,
Mike
