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<12) { $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="Roller-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<12) { $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

ROLLER HOCKEY

"; } ?>

TEAM:

TIME OUT

TEAM:

TIME OUT

CAPTAIN:

1

 

2

 

CAPTAIN:

1

 

2

 

S.No

GOAL SCORER PLAYER

NAME OF PLAYER

JNo

Pos.

 

CARDS

GOAL SCORER PLAYER

NAME OF PLAYER

J.No

Pos.

 

CARDS

ID

Sign

B

B

R

ID

Sign

B

B

R

".$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']."