Hi,
I would like to create a search that accepts multiple optional parameters from 4 different form fields. 2 of the fields are drop down list and the other 2 are text fields. Only parameters that are provided with values will be used to filter the results. This is useful for dynamic searches when the user selects or provides values for one or more fields to be searched, but not all of the fields are required. Bellow is the form I've created and the PHP/SQL created by Dreamweaver; this SQl statement works, however I can't get the SQL statement to search only what I've chosen in the form. Please, I need help.
==========
HTML FORM
<FORM name="multipleSearch" method="post" action="getmultiplesearch.php">
Select Parameter:
<SELECT name="Param">
<option value="0"></option>
<option value="AG">Total Silver</option>
<option value="AS">Total Arsenic</option>
</SELECT>
Select Location:
<SELECT name="Location">
<option value="0"></option>
<option value="Mississipi River">Mississipi River</option>
<option value="CRVL Reservoir top">Reservoir</option>
</SELECT>
Enter Date Range:
From:
<input type="text" name="Startdate">
To:
<input type="text" name="Enddate">
<input type="submit" name="multipleSubmit" value="Submit Search">
</FORM>
===================================
Search page (getmultiplesearch.php)
<?php
$rsGetresultsvarParam = "1";
if (isset($HTTP_POST_VARS["Param"])) {
$rsGetresultsvarParam = $HTTP_POST_VARS["Param"];
}
?><?php
$rsGetresultsvarLocation = "1";
if (isset($HTTP_POST_VARS["Location"])) {
$rsGetresultsvarLocation = $HTTP_POST_VARS["Location"];
}
?><?php
$rsGetresultsvarStartdate = "1";
if (isset($HTTP_POST_VARS["Startdate"])) {
$rsGetresultsvarStartdate = $HTTP_POST_VARS["Startdate"];
}
?><?php
$rsGetresultsvarEnddate = "1";
if (isset($HTTP_POST_VARS["Enddate"])) {
$rsGetresultsvarEnddate = $HTTP_POST_VARS["Enddate"];
}
?>
$rsGetresults = $Connection2->Execute("SELECT Location, Parameter, SampleDate, Description FROM dataTable
WHERE Parameter LIKE Parameter = '" .($rsGetresultsParam) . "'
OR Location = '" . ($rsGetresultsLocation) . "'
OR SampleDate BETWEEN '" . ($rsGetresultsvarStartdate) . "' AND '" . ($rsGetresultsvarEnddate) . "'") or KT_DIE($Connection2->ErrorNo(),$Connection2->ErrorMsg());
