PHP?MySql search

Need search page with results for public section of a site. Information on each product is stored on three tables (already exit 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.