Reset Dropdown List in Search Form
I have a search form on the results page where I am having trouble clearing the value in the dropdown list. I would like to keep the selected value during a search but also be able to clear and reset the form so all results show, and the list returns to the default position. Is this possible?
I tried clearing the session variable with a link and clear=true on the results page, and on the results page and the search page, and also trying to use a separate page to try to reset the list. I think the problem maybe the recordset select statement which includes an AS column.
mysql_select_db($database_newbbcpeConn, $newbbcpeConn);
$query_WADADynListendtimelist = "SELECT endtimelist.EndTimeListID, endtimelist.EndTime, TIME_FORMAT( endtimelist.EndTime, '%l:%i %p') AS EndingTime FROM endtimelist ORDER BY endtimelist.EndTime ASC";
setQueryBuilderSource($query_WADADynListendtimelist,$WADbSearch1,false);
$query_limit_WADADynListendtimelist = sprintf("%s LIMIT %d, %d", $query_WADADynListendtimelist, $startRow_WADADynListendtimelist, $maxRows_WADADynListendtimelist);
$WADADynListendtimelist = mysql_query($query_limit_WADADynListendtimelist, $newbbcpeConn) or die(mysql_error());
$row_WADADynListendtimelist = mysql_fetch_assoc($WADADynListendtimelist);
How do I reset the search so that when the search button is pressed it loads all the
results and resets the dynamic list to the default selected value?
Thank you for any help.