Multi - Table Searching

[facets]

Hi Gang,

How would I go about searching multiple tables from a MySQL DB from a 'searchNow' function.
(The form has many submits, like view this, add that etc)

So I'd have multple input criteria,
(12 X)Checkbox and drop down, (2 X)Checkbox and text input.
And 1, some or all might be checked (ticked)

Does anyone have any pointers that may be of use?

Cheers, Will.

[kburger]

Not enough info to go on here. But the basic idea is to build up your query using the values submitted from the form. One thing though, depending upon how you write it, the text box could be a security hole. I can't really give you much more help without seeing your form(s) and the structure of the tables being queried.

[facets]

i've moved this over to :

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10303155

as i've now worked out how to query the multiple tables with LEFT JOINS etc, now how do I display the data. TA Will.