MySQLi search form with additional parameter

I have a search page that is working correctly (kids_shift_search1.php, attached), but I needed to add an additional search parameter (event) to it. So far it's been unsuccessful. Something seems to be limiting my results to 1, but I cannot figure out what it is. The current page is attached also (kids_shift_search.php).

all of the peramiters are set to Integer.

Edit the recordset, and edit each variable, make sure the type is set to integer and the comma separated list option is checked.

Checking the comma seperated list boxes fixed it! Thanks!

How can I change the query so that the first option would be "Show All" and it would return any result from that list?

add an option with a blank value:

<option value="">show all</option>

and in the recordset SQL edit the condition to use a second OR comparison for -1 = newPerameter.

for example, you curently have the condition in the SQL for:
kids_program_time.id IN (WAQB_Param1)

and the WAQB_Param1 variable has the run time value set to use the time URL variable

adit the SQL To:
(kids_program_time.id IN (WAQB_Param1) OR -1 = WAQB_Param1_2)


then create another varaiable using the same settings as WAQB_Param1 variable but named WAQB_Param1_2, in the WAQB_Param1_2 variable, don't check the Comma separated list option.

Perfect!
I suppose I can do the same thing for a "none" value in each column by setting the parameter value to "null" or "0" whichever the database default is?

yes, that is correct.