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 > <
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.
*Need this in 24 to 48 hours.