Best approach for complex search

[raymond_feliciano]

I have a quick question. I am trying to create a complex search form which will join nth number of tables. Here is the process for doing the search the way I have it setup so far.

The user clicks the advance search link and a jquery popup is displayed.

The user will see the first set of checkboxes which he can check and under the first set of checkboxes the user will be able to click a link stating And | Or.

If the user clicks the And link a second set of checkboxes will be displayed using jquery containing the same values as the first set of checkboxes.

Now if the user checks the first checkbox in the first set and clicks the second checkbox in the second set these values will be used to query the database.

I tried using select boxes but when the form is submitted all the values are sent over instead of what the user pick. Is this the best way to do it or should it be done a different way.

[QuickOldCar]

You can use mysql fulltext search

http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html

 

Here was a post I did for an example, same post also leads to another post I did with some multiple query examples.

http://www.phpfreaks.com/forums/index.php?topic=358927.0