Need search page with results for public section of a site.
Information on each product is stored on three tables (already exists from a CMS system).
Main info on one table, with photo names on second (associated by ID), and 2 fields on a third table with odd setup (see below*).
Need to search date fields for "within last 30 days" etc.
Need to search some fields using greater than, less than
Need to search some fields using multiple selection.
Not searching photo table, but pulling images from once query done.
*Third table causes an interesting challenge
Need to search a field in this table from two different inputs, and not display duplicate entries if the Product was already found while searching the first table.
Sounds like an interesting work. I have done a number of mysql optimizations, this should not be a problem. Can finish it within a day, and pay me only if you are happy.
: Augustine