To filter on a column value 'event' from a do while repeat region, I have the following. When checked, it should display by 'event'.
a) How do I make these checkboxes send (to the same page) so the filter can pick up on them? In an array which would be defined by GET variable on the page? //assuming 'do-while' and not 'do-if'
<td width="20" height="20" ><input type="checkbox" name="style[]"
value="<?php echo $row_Style['event']; ?>"<?php echo $row_Style['name']; ?>"checked":""; ?>
</td>
<td width="207" ><?php echo $row_Style['name']; ?></td>
b) Must this be sent with a button or could it be done "on check" ? To hold values that would be automatically called, for user "favorite events" I assume they should be held in a many-to-many relation type table which would mean another join. Yet what I would like to avoid is a table update every time a checkbox selection is made. Can anyone make a suggestion so that favorite "events" are automatically called yet any "events" in the do while may be checked or unchecked at any time to be filtered on the query?
d) Is there an alternative to using something like the below on the page, to pick up the array values, that the query could filter on (picking up array values from the do while, above).
I'm asking this since I don't know beforehand how many styles ( style[] 's ) any given user may have and that the number of these may change at any time.
<?php echo $GET['style'][0];?>
<?php echo $GET['style'][1];?>
<?php $one= $GET['style'][0];
$two= $GET['style'][1];?>
