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.

Kemahiran: PHP

Lihat lagi: php id, first search, to search, third, search images, odd, mysql query, exit, cms php, Challenge, mysql product search, duplicate table, field php, php display, mysql search table, php search page, display mysql, photo setup, php mysql query multiple, php using

Tentang Majikan:
( 0 ulasan ) Bedford, Canada

ID Projek: #6403