real_escape_string($teama).'" AND status != "delete" order by CONVERT(appno,UNSIGNED INTEGER)'; //echo $databaseQuery; $i=0; $result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result3)) { $teamalist[$i] = array(); $teamalist[$i]['appno'] = trim($row["appno"]); $teamalist[$i]['sname'] = trim($row["sname"]); //echo $teamalist[i]['sname']; $teamalist[$i]['jno'] = trim($row["jerseyno"]); $teamalist[$i]['ptype'] =" " ; if(trim($row["hockeyplayertype"])=="Player") { $teamalist[$i]['ptype'] ="P"; } if(trim($row["hockeyplayertype"])=="GoalKeeper1") { $teamalist[$i]['ptype'] ="GK1"; } if(trim($row["hockeyplayertype"])=="GoalKeeper2") { $teamalist[$i]['ptype'] ="GK2"; } if(trim($row["hockeyplayertype"])=="GoalKeeper3") { $teamalist[$i]['ptype'] ="GK3"; } if(trim($row["hockeyplayertype"])=="Captain") { $teamalist[$i]['ptype'] ="C"; } $i=$i+1; } while($i<16) { $teamalist[$i] = array(); $teamalist[$i]['appno'] = " "; $teamalist[$i]['sname'] = " "; $teamalist[$i]['jno'] = " "; $teamalist[$i]['ptype'] = " "; $i=$i+1; } $databaseQuery1 = 'SELECT appno, sname, agegroup, gender, club,quadhockey, inlinehockey, hockeyplayertype, jerseyno FROM applications WHERE skatertype="Inline-Hockey" and agegroup="'.$agq.'" and gender="'.$genderq.'" and club ="'.$con->real_escape_string($teamb).'" AND status != "delete" order by CONVERT(appno,UNSIGNED INTEGER)'; //echo $databaseQuery; $i=0; $result4 = mysqli_query($con,$databaseQuery1) or die('Query failed: ' . mysqli_error()); while($row = mysqli_fetch_array($result4)) { $teamblist[$i] = array(); $teamblist[$i]['appno'] = trim($row["appno"]); $teamblist[$i]['sname'] = trim($row["sname"]); //echo $teamalist[i]['sname']; $teamblist[$i]['jno'] = trim($row["jerseyno"]); $teamblist[$i]['ptype'] =" "; if(trim($row["hockeyplayertype"])=="Player") { $teamblist[$i]['ptype'] ="P"; } if(trim($row["hockeyplayertype"])=="GoalKeeper1") { $teamblist[$i]['ptype'] ="GK1"; } if(trim($row["hockeyplayertype"])=="GoalKeeper2") { $teamblist[$i]['ptype'] ="GK2"; } if(trim($row["hockeyplayertype"])=="GoalKeeper3") { $teamblist[$i]['ptype'] ="GK3"; } if(trim($row["hockeyplayertype"])=="Captain") { $teamblist[$i]['ptype'] ="C"; } $i=$i+1; } while($i<16) { $teamblist[$i] = array(); $teamblist[$i]['appno'] = " "; $teamblist[$i]['sname'] = " "; $teamblist[$i]['jno'] = " "; $teamblist[$i]['ptype'] = " "; $i=$i+1; } } else { echo "Invalid Requests".$_GET["filterteam"]; } ?>

MATCH NO.     :
AGE GROUP :
TEAMS      : Vs
Date :                   Start Time :               Finish Time :

56TH NATIONAL ROLLER SKATING CHAMPIONSHIP - 2018

VISAKHAPATNAM

TOSS

STRIKE

SIDE

INLINE HOCKEY

"; } ?>

TEAM:

TIME OUT

TEAM:

TIME OUT

CAPTAIN:

S.No

GOAL SCORER PLAYER

NAME OF PLAYER

JNo

Pos.

CARDS

GOAL SCORER PLAYER

NAME OF PLAYER

J.No

Pos.

CARDS

Sign

".$sl."

".$teamalist[$rw]['sname']."

".$teamalist[$rw]['jno']."

".$teamalist[$rw]['ptype']."

".$teamalist[$rw]['appno']."

".$teamblist[$rw]['sname']."

".$teamblist[$rw]['jno']."

".$teamblist[$rw]['ptype']."

".$teamblist[$rw]['appno']."