I need a php function creating which creates a dynamic mysql statement based on the options chosen. You can see the start of this function and the options available here: [url removed, login to view] If you click to search you can see the structure of the posted data.
The table that this function will be querying has a structure as follows:
contact_id field_id field_value
1 2 UK
1 3 testing
2 2 USA
At the end of the query I need to be left with a unique string of contact_id's.
Based on the page and the table structure I'm not sure if it would be possible to create one dynamic mysql statement or we would have to have a different query for each field_id.
Let me know your thoughts.