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)
So far I have the HTML sorted, values etc (Example
Code: Select all
<input type="e;checkbox"e; name="e;paperCategory"e; id="e;checkbox"e; value="e;on"e;></td>
<td width="e;50px"e;><select name="e;paperCategoryId"e;>
<option value="e;"e;>-- Select Option --</option>
<option value="e;1"e;>Standard</option>
<option value="e;2"e;>Non Standard</option>
<option value="e;3"e;>Non Approved</option>
</select></code>
But i'm unsure on how to set up the function that passes multiple variables depending on what was selected.
Any pointers would be greatly appreciated..
TIA, Will