MySQLi query where target from $_GET[] Query not returning values on page
Hello Support,
Please my MySQLi query where target from $_GET[] Query not returning values on page. Please see code below
<?php
$rsValidateParticipant = new WA_MySQLi_RS("rsValidatet",$DBMS,10);
$rsValidateParticipant->setQuery("SELECT regno, title, surname, othernames, state, country, assembly, sex, maritalstatus, age, phone, email, @curRow := @curRow + 1 AS sn FROM registration JOIN (SELECT @curRow := 0) r WHERE assembly = ? ORDER BY assembly ASC");
$rsValidateParticipant->bindParam("s", "".(isset($_GET['assembly'])?$_GET['assembly']:"") ."", "-1"); //colname
$rsValidateParticipant->execute();
?>
The code is to pull all records based on the selected Assembly but when the assembly is selected from the drop down menu, nothing happens; no data is loaded on the page
Attached is the page.
Thank you