"; $databaseQuery = 'SELECT club,count(*) as c FROM applications group by club'; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result)) { echo ""; } echo "

".$row["club"]."

".$row["c"]."

View List

"; echo "Summary
"; $databaseQuery = 'SELECT status,count(appno) as c FROM applications group by status order by c desc'; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result)) { if($row["status"]!="") { echo ""; } else { echo ""; } } echo "

".$row["status"]."	".$row["c"]."
Unverified	".$row["c"]."

"; echo "Participation Summary
"; $databaseQuery = 'SELECT skatertype,count(appno) as c FROM applications group by skatertype order by c desc'; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result)) { if($row["skatertype"]!="") { echo ""; } else { echo ""; } } echo "

".$row["skatertype"]."	".$row["c"]."
Unverified	".$row["c"]."

"; if ($_SERVER['REQUEST_METHOD'] == 'GET') { $club=$_GET['team']; $skey=$_GET['team']; $stype=$_GET['stype']; if($stype=="" || $stype=="all") { $stype="%"; } $databaseQuery = 'SELECT * FROM applications WHERE (skatertype like "%'.$stype.'%") and (club like "%'.$con->real_escape_string($club).'%") order by agorder,gender desc,skatertype,CONVERT(appno,UNSIGNED INTEGER)'; $result2 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); $skey=$club; echo "Summary for ".$club."
"; $databaseQuery = 'SELECT status,count(appno) as c FROM applications WHERE (club like "%'.$con->real_escape_string($club).'%") group by status order by c desc'; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result)) { if($row["status"]!="") { echo ""; } else { echo ""; } } echo "

".$row["status"]."	".$row["c"]."
Unverified	".$row["c"]."

"; } else { $databaseQuery = 'SELECT * FROM applications WHERE (skatertype like "%'.$stype.'%") order by agorder,gender desc,skatertype,CONVERT(appno,UNSIGNED INTEGER) '; $result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); $skey="All Applications"; $stype="%"; } } else if($club !="") { $stype="%"; if ($_SERVER['REQUEST_METHOD'] == 'GET') { //$club=$_GET['team']; // $skey=$_GET['team']; $stype=$_GET['stype']; if($stype=="" || $stype=="all") { $stype="%"; } } $databaseQuery = 'SELECT * FROM applications WHERE (skatertype like "%'.$stype.'%") and (club like "%'.$con->real_escape_string($club).'%") order by agorder,gender desc,skatertype,CONVERT(appno,UNSIGNED INTEGER)'; $result2 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); $skey=$club; } else { echo 'Please Enter Correct Login Credentials..'; loginbox(); exit(); } if (function_exists('date_default_timezone_set')) { date_default_timezone_set('Asia/Calcutta'); } if($stype=="%") { $stype="all"; } echo '

' .mysqli_num_rows($result2) . ' Results found for "'.$club.'", "'.$stype.'" as on '.date('d-m-Y h:i:s A').'.

'; echo '

Filters: All  |  '; echo 'Tenacity  |  '; echo 'Speed-Quad  |  '; echo 'Speed-Inline  |  '; echo 'Artistic  |  '; echo 'Hockey  |  '; echo 'Freestyle  

PRINT

'; if($result2) { //id="example" ?>