DataAssist Search not working
I have a .php displaying all of the golf course games (see below) on the page I have 3 radio buttons so that the visitor can select to view all, team games only or individual games. Nothing seems to happen when any of the radio buttons are selected.
SELECT games.gamesTitle, games.gamesDesc,teamgame, if(teamgame='Y','Yes','No') AS v_team,teamgame
FROM games
WHERE active = 'Y' and gamesDesc <>''
ORDER BY gamesTitle ASC LIMIT 25
(with a repeat region)
I have a place on the page for visitors to select from a radio group
<form id="frmSearch">
<table>
<tr>
<td>
<input type="radio" name="team[]" value=""> Show All |
<input type="radio" name="team[]" value="Y">Team Games |
<input type="radio" name="team[]" value="N">Individual Games
<input name="Search" type="submit" id="Search" value="Search" >
</td>
</tr>
</table>
</form>
Below is the search statement generated by the DataAssist behaviour
<?php
$searchrs_games_1 = new WA_MySQLi_Search("rs_games","0=0");
if (isset($_POST["Search"]) || isset($_POST["Search_x"])) {
$searchrs_games_1->clearSearch();
$searchrs_games_1->setSearch(array("type"=>"Value", "comparison"=>"=", "join"=>"AND"), array("teamgame"), "s", "".((isset($_GET["team"]))?$_GET["team"]:"") ."");
}
?>
Also here is the before and after url
Before
http://mussolinetestserver.site/publicPages/gamesViewPublic.php
After
http://mussolinetestserver.site/publicPages/gamesViewPublic.php?team%5B%5D=N&Search=Search
I have attached the php page.
Thank you in advance