Jump to content

names below the text

miniu

By miniu
in PHP Coding Help

Recommended Posts

miniu Member

miniu

Posted
Posted

Hi I have a script where I have games to assign by referees. Right now when the referee goes to his page he sees that he is assigned and also sees that other referees are assigned for that game. But he see only if there are pending, accepted or rejected. How can I make it that they will see also the name of the referees?

 

below is the code:

<?php include("connect.php");
include("admin.session.php");
$LeftLinkSection = 1;
$pagetitle="Assigned Games";

if(isset($_GET['did']))
{
$sql="delete from games where id=".$_GET['did'];
$res=mysql_query($sql);
echo mysql_error();
header('location:message.php?mid=3');
}

?>
<HTML>
<HEAD><title><?=Site_Title; ?></title>
<SCRIPT language="javascript" src="body.js"></SCRIPT>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<link rel="stylesheet" href="main.css" type="text/css">
<style type="text/css">
<!--
.style3 {color: #FFFFFF}
-->
</style>
</HEAD>
<BODY leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 class="th-a">
  <TR><TD height=60 valign="top"  colspan="2" bgColor="#ffffff"><? include("top.php") ?></td></TR>  
  <tr>
  		<td width="20%" valign="top" bgcolor="#1c6995"><? include("left.php"); ?></td>
	<td width="80%" valign="top" bgcolor="#FFFFFF" height="480">
		<TABLE width="97%"  border=0 cellPadding=0 cellSpacing=0 align="center">
			<TR><TD width="100%"  class="H1"> </TD></TR>
			<TR><TD align="center" width="100%" class="a-l"><?php echo $Message2 ; ?></TD></TR>
	    <TR>
		<? if($msg!="") { ?>
		<TR><TD align="center" width="100%" class="a-l"><font color="red"><b>User Deleted Successfully</b></font></TD></TR>
	    <TR>
		<? } ?>
	      <TD width="100%" class="H1">Manage <?=$pagetitle?></TD>
	    </TR>
			<TR><TD background="images/vdots.gif"><IMG height=1 src="images/spacer.gif" width=1 border=0></TD></TR>
		  <tr>
				<TD>

				<FORM  name="order" action="#" method="post">
    				  <TABLE cellSpacing=0 cellPadding=1 border=0 >
							<tr><td colspan="25" height="20"><b>View By Division Name</b></td></tr>
							<?=$prs_pageing->order();?>
					</TABLE>
				  </form>

<?	
  	if($_GET["order"])
{
	$order=$_GET["order"];
    $strQueryPerPage="select ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,ag.id as agid,g.id,g.gid,d.dname,ht.tname as htname,at.tname as atname from games g inner join divisions d on g.div_id=d.id inner join teams ht on g.home_team_id=ht.id inner join teams at on g.away_team_id=at.id inner join assigned_games ag on g.gid=ag.gid where (main_ref_id=".$_SESSION["UsErId"]." or ast_ref_id1=".$_SESSION["UsErId"]." or ast_ref_id2=".$_SESSION["UsErId"].") and d.dname like '$order%'";
}
else
  	$strQueryPerPage="select ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,ag.id as agid,g.id,g.gid,d.dname,ht.tname as htname,at.tname as atname from games g inner join divisions d on g.div_id=d.id inner join teams ht on g.home_team_id=ht.id inner join teams at on g.away_team_id=at.id inner join assigned_games ag on g.gid=ag.gid where main_ref_id=".$_SESSION["UsErId"]." or ast_ref_id1=".$_SESSION["UsErId"]." or ast_ref_id2=".$_SESSION["UsErId"];

if(isset($_GET['sort']))
	$strQueryPerPage.=" order by ".$_GET['sort']." ".$_GET['ordby'];
else
	$strQueryPerPage.=" order by g.id desc";

//echo $strQueryPerPage;

$strResultPerPage=mysql_query($strQueryPerPage);
$strTotalPerPage=mysql_affected_rows(); 	
?>
		<div align="center">
		<script type="text/javascript"><!--
			google_ad_client = "pub-4703789267650596";
		/* 728x90, utworzono 10-03-10 */
			google_ad_slot = "0969661517";
			google_ad_width = 728;
			google_ad_height = 90;
		//-->
		</script>
		<script type="text/javascript"
			src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
		</script>
	  
	  <script type="text/javascript"><!--
			google_ad_client = "pub-4703789267650596";
		/* 728x15, utworzono 09-12-14 */
			google_ad_slot = "0676154885";
			google_ad_width = 728;
			google_ad_height = 15;
		//-->
		</script>
		<script type="text/javascript"
			src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
		</script>
	    </div>		
          <FORM name="form2" action="#" method="post">          
          <TABLE width="100%" height="89" border=1 cellSpacing=0 class=t-a>
            <!--DWLayoutTable-->
            <TBODY>
              <TR class="th-a"> 
		     <TD colspan="8">					 
				 <?
					$result=$prs_pageing->number_pageing($strQueryPerPage,15,7);
				?>			  </TD>                 
        	 </TR>		

              <TR class=th-a>
                <TD width="13%" align="left"><a href="assigned_games.php?sort=g.gid&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Game ID</a></TD> 
			<TD width="12%" align="left"><a href="assigned_games.php?sort=d.dname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Division Name</a></TD> 
		  	<TD width="11%" align="left"><a href="assigned_games.php?sort=ht.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Home Team Name</a></TD>
			<TD width="11%" align="left"><a href="assigned_games.php?sort=at.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Away Team Name</a></TD>
			<TD width="11%" align="left"><a href="assigned_games.php?sort=ag.main_ref_accept&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Main Referee</a></TD>
			<TD width="11%" align="left"><a href="assigned_games.php?sort=ag.ast_ref1_accept&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 1</a></TD>
			<TD width="11%" align="left"><a href="assigned_games.php?sort=ag.ast_ref2_accept&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 2</a></TD>
			<TD width="16%" align="center"><span class="style3">Option</span></TD>
              </TR>
          <?php
	  $tr="#f4f4f4";
	  $clr=1;
		while($row = mysql_fetch_object($result))
		{

			if($tr=="#FFFFFF")
			{
				$tr="#efefef";
				$col="#000000";
			}
			else
			{
				$tr="#FFFFFF";
				$col="#000000";
			}
			$tmpid = $row->id ;

			$tmpid = "";

        ?>
              <tr bgcolor="<? echo $tr; ?>">
      	    <TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->gid); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->dname); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->htname); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->atname); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? if($row->main_ref_accept=='P') echo "<font color='#FF9900'><strong>Pending</strong></font>"; if($row->main_ref_accept=='A') echo "<font color='#006633'><strong>Accepted</strong></font>"; if($row->main_ref_accept=='R') echo "<font color='#FF0000'><strong>Rejected</strong></font>"; ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? if($row->ast_ref1_accept=='P') echo "<font color='#FF9900'><strong>Pending</strong></font>"; if($row->ast_ref1_accept=='A') echo "<font color='#006633'><strong>Accepted</strong></font>"; if($row->ast_ref1_accept=='R') echo "<font color='#FF0000'><strong>Rejected</strong></font>"; ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? if($row->ast_ref2_accept=='P') echo "<font color='#FF9900'><strong>Pending</strong></font>"; if($row->ast_ref2_accept=='A') echo "<font color='#006633'><strong>Accepted</strong></font>"; if($row->ast_ref2_accept=='R') echo "<font color='#FF0000'><strong>Rejected</strong></font>"; ?></font></TD>
			<TD align="center"><input name="button" type="button" class="bttn-s" onClick="location.href='view_assigned_game.php?id=<?php echo $row->agid; ?>'" value="View">
		      </TD>
              </TR>
              <?  
		  		$parentary = NULL ;
		  	}	  ?>
            <input type=hidden name="total" value="<? echo $strTotalNewRow; ?>">
            <TR align=center> 
                <TD colSpan=6>
                <?
		 	if(!$strTotalPerPage)
			{
		 ?>
                  <strong>No Game Detail to Display</strong> 
                  <?
		 	}
		 ?>                </TD>
            </TR>
            <TR align=center> 
              <TD colSpan=9>              </TD>
            </TR>
          </TABLE>
        

        </FORM>
				</TD>
		  </TR>
		</TABLE>
	</td>
  </tr>
</TABLE>
</BODY></HTML>

 

Link to comment
https://forums.phpfreaks.com/topic/194795-names-below-the-text/
Share on other sites
miniu Member

miniu

Posted
  • Author
Posted

for example there Is a file called "manage_referee_to_game" and in this file you can see both, the status and the names.

 

The code is below:

<?php include("connect.php");
include("admin.session.php");
$LeftLinkSection = 1;
$pagetitle="Referees To Game";

if(isset($_GET['did']))
{
$sql="delete from assigned_games where id=".$_GET['did'];
$res=mysql_query($sql);
echo mysql_error();
header('location:message.php?mid=27');
}

if($_POST['sub11']==1)
{
//echo 'ts'; 
}

if($_GET['league_id']!='')
$league=$_GET['league_id'];


?>
<HTML>
<HEAD><title><?=Site_Title; ?></title>
<SCRIPT language="javascript" src="body.js"></SCRIPT>
<script>
function show_divisions(val)
{
window.location.href='manage_referees_to_game.php?league_id=' + val;

}
function show_getgames()
{
if(document.getElementById('txtfromdate').value!='' && document.getElementById('txttodate').value=='')
{
	alert('Please Select To Date');
	document.getElementById('txttodate').focus();
	return false;
}
if(document.getElementById('txttodate').value!='' && document.getElementById('txtfromdate').value=='')
{
	alert('Please Select From Date');
	document.getElementById('txtfromdate').focus();
	return false;
}
if(document.getElementById('txttodate').value < document.getElementById('txtfromdate').value)
{
	alert('To Date can not be less then From Date');
	document.getElementById('txttodate').focus();
	return false;
}

document.getElementById('sub11').value=1;
document.frmgetgames.submit();
}
function clearall()
{
document.getElementById('txtfromdate').value='';
document.getElementById('txttodate').value='';
document.getElementById('refsel').value='';
document.getElementById('drpdivisions').value='';

}
function openWin(pageToLoad, winName, width, height, center,scrollbar){

  if ((parseInt(navigator.appVersion) >= 4 ) && (center)){
	        xposition = (screen.width - width) / 2;
	        yposition = (screen.height - height - 100) / 2;
args = "width=" + width + "," + "height=" + height + "," + "location=0," + "menubar=0," + "resizable=no," + "scrollbars=" + scrollbar + "," + "status=0," + "titlebar=0," + "toolbar=0," + "hotkeys=0," + "screenx=" + xposition + "," + "screeny=" + yposition + "," + "left=" + xposition + "," + "top=" + yposition;
newWindow = window.open(pageToLoad,winName,args);	
window.focus;
}
}
</script>
<script src="calendar.js"></script>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<link rel="stylesheet" href="main.css" type="text/css">
<style type="text/css">
<!--
.style3 {color: #FFFFFF}
-->
</style>
</HEAD>
<BODY leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 class="th-a">
  <TR><TD height=60 valign="top"  colspan="2" bgColor="#ffffff"><? include("top.php") ?></td></TR>  
  <tr>
  		<td width="20%" valign="top" bgcolor="#1c6995"><? include("left.php"); ?></td>
	<td width="80%" valign="top" bgcolor="#FFFFFF" height="480">
		<TABLE width="97%"  border=0 cellPadding=0 cellSpacing=0 align="center">
			<TR><TD width="100%"  class="H1"> </TD></TR>
			<TR><TD align="center" width="100%" class="a-l"><?php echo $Message2 ; ?></TD></TR>
	    <TR>
		<? if($msg!="") { ?>
		<TR><TD align="center" width="100%" class="a-l"><font color="red"><b>User Deleted Successfully</b></font></TD></TR>
	    <TR>
		<? } ?>
	      <TD width="100%" class="H1">Manage <?=$pagetitle?></TD>
	    </TR>
			<TR><TD background="images/vdots.gif"><IMG height=1 src="images/spacer.gif" width=1 border=0></TD></TR>
		  <tr>
				<TD>

				<FORM  name="order" action="#" method="post">
    				  <TABLE cellSpacing=0 cellPadding=1 border=0 >
							<tr><td colspan="25" height="20"><b>View By Main Referee Name</b></td></tr>
							<?=$prs_pageing->order();?>
					</TABLE>
				  </form>
				  <br><form name="frmgetgames" id="frmgetgames" method="post">
				  <table cellpadding="0" cellspacing="0" border="0">
			<tr>
                              <td width="100%" colspan="2" align="center">
                            From Date: <input type="text" name="txtfromdate" readonly="true" id="txtfromdate" size="15" value="<?=stripslashes($_REQUEST['txtfromdate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txtfromdate'));"> Select Date</a>   To Date: <input type="text" name="txttodate" readonly="true" id="txttodate" size="15" value="<?=stripslashes($_REQUEST['txttodate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txttodate'));"> Select Date</a>      <input type="button" value="Get Games" onClick="show_getgames();"><input type="hidden" id="sub11" name="sub11" value="0">  <input type="button" value="Clear" onClick="clearall();">
                              </td>
                            </tr>
						<tr><td colspan="2"> </td></tr>
			<tr>
                              <td width="100%" colspan="2" align="left"><select id="refsel" name="refsel">
						  <option value="" <? if($_POST['refsel']==' ') echo "selected='selected'"; ?>>--Select--</option>
	<option value="0" <? if($_POST['refsel']!='') { if($_POST['refsel']==0) echo "selected='selected'"; } ?>>Games with NO REFEREE Assigned</option>
	<option value="1" <? if($_POST['refsel']==1) echo "selected='selected'"; ?>>Games with NO Main Referee Assigned</option>
<option value="2" <? if($_POST['refsel']==2) echo "selected='selected'"; ?>>Games with NO Assistant Referee 1 Assigned</option>
<option value="3" <? if($_POST['refsel']==3) echo "selected='selected'"; ?>>Games with NO Assistant Referee 2 Assigned</option>
						  </select>  <select name="drpleague" id="drpleague" style="width:150px" onChange="show_divisions(this.value)">
						  <option value="">--Select--</option>
						  <? 
						  	  $sql_league="select * from league";
							  $res_league=mysql_query($sql_league);
							  while($row_league=mysql_fetch_object($res_league))
							  {
						  ?>
						  <option value="<?=$row_league->id?>" <? if($row_league->id==$league) echo "selected='selected'"; ?>><?=stripslashes($row_league->league_name)?></option>
						  <? } ?>
						  </select>  <? if($league!='') { ?><select id="drpdivisions" name="drpdivisions">
						  	<option value="">--Select Division--</option>
							<? 
								$sql_division="select * from divisions where league_id=".$league." order by dname";
								$res_division=mysql_query($sql_division);
								while($row_division=mysql_fetch_object($res_division))
								{
							?>
							<option value="<?=$row_division->id?>" <? if($_POST['drpdivisions']==$row_division->id) echo "selected='selected'"; ?>><?=stripslashes($row_division->dname);?></option>
							<? } ?>
						  </select><? } ?>
						  </td></tr>

			</table></form><br>

<?	
  	if($_GET["order"])
{
	$order=$_GET["order"];
  $strQueryPerPage="select lea.league_name,ht.tname as htname,at.tname as atname,d.dname,g.gdate,g.gtime,ag.id,ag.gid,ag.main_ref_id,ag.ast_ref_id1,ag.ast_ref_id2,ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,r1.fname as r1fname,r1.lname as r1lname,r2.fname as r2fname,r2.lname as r2lname,r3.fname as r3fname,r3.lname as r3lname from assigned_games ag left outer join referees r1 on ag.main_ref_id=r1.id left outer join referees r2 on ag.ast_ref_id1=r2.id left outer join referees r3 on ag.ast_ref_id2=r3.id left outer join games g on ag.gid=g.gid left outer join divisions d on g.div_id=d.id left outer join league lea on g.league_id=lea.id left outer join teams ht on g.home_team_id=ht.id left outer join teams at on g.away_team_id=at.id where r1.fname like '$order%'";
}
else
  	$strQueryPerPage="select lea.league_name,ht.tname as htname,at.tname as atname,d.dname,g.gdate,g.gtime,ag.main_ref_id,ag.ast_ref_id1,ag.ast_ref_id2,ag.id,ag.gid,ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,r1.fname as r1fname,r1.lname as r1lname,r2.fname as r2fname,r2.lname as r2lname,r3.fname as r3fname,r3.lname as r3lname from assigned_games ag left outer join referees r1 on ag.main_ref_id=r1.id left outer join referees r2 on ag.ast_ref_id1=r2.id left outer join referees r3 on ag.ast_ref_id2=r3.id left outer join games g on ag.gid=g.gid left outer join divisions d on g.div_id=d.id left outer join league lea on g.league_id=lea.id left outer join teams ht on g.home_team_id=ht.id left outer join teams at on g.away_team_id=at.id where 1=1";

//echo $strQueryPerPage;

if($_POST['sub11']==1)
{
	if($_REQUEST['txtfromdate']!='')
	{
	$txtfromdate=$_REQUEST['txtfromdate'];
	$txtfromdate_arr=explode("-",$txtfromdate);
	$txtfromdate=$txtfromdate_arr[2].'-'.$txtfromdate_arr[0].'-'.$txtfromdate_arr[1];

	$txttodate=$_REQUEST['txttodate'];
	$txttodate_arr=explode("-",$txttodate);
	$txttodate=$txttodate_arr[2].'-'.$txttodate_arr[0].'-'.$txttodate_arr[1];

	$strQueryPerPage.=" and g.gdate >='".$txtfromdate."' and g.gdate<='".$txttodate."'";
	}

	if($_POST['refsel']!='')
	{
		if($_POST['refsel']==0)
		{
			$strQueryPerPage.=" and ag.main_ref_id=0 and ag.ast_ref_id1=0 and ag.ast_ref_id2=0";

		}
		if($_POST['refsel']==1)
		{
			$strQueryPerPage.=" and ag.main_ref_id=0";

		}
		if($_POST['refsel']==2)
		{
			$strQueryPerPage.=" and ag.ast_ref_id1=0";

		}
		if($_POST['refsel']==3)
		{
			$strQueryPerPage.=" and ag.ast_ref_id2=0";

		}

   }
   
   if($_POST['drpdivisions']!='')
   {
   		$strQueryPerPage.=" and d.id=".$_POST['drpdivisions'];
		$drp_division=$_POST['drpdivisions'];
   }
   
   if($_POST['drpleague']!='')
   {
   		$strQueryPerPage.=" and lea.id=".$_POST['drpleague'];
		$league=$_POST['drpleague'];
   }


}

if(isset($_GET['sort']))
	$strQueryPerPage.=" order by ".$_GET['sort']." ".$_GET['ordby'];
else
	$strQueryPerPage.=" order by ag.id desc";

//echo $strQueryPerPage;

$strResultPerPage=mysql_query($strQueryPerPage);
$strTotalPerPage=mysql_affected_rows(); 	
?>

          <FORM name="form2" action="#" method="post">          
          <TABLE width="100%" height="89" border=1 cellSpacing=0 class=t-a>
            <!--DWLayoutTable-->
            <TBODY>
              <TR class="th-a"> 
		     <TD colspan="10">					 
				 <?
					$result=$prs_pageing->number_pageing($strQueryPerPage,15,7);
				?>			  </TD>                 
        	 </TR>		

              <TR class=th-a>
		  	<TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=lea.league_name&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">League Name</a></TD> 
                <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=d.dname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Division</a></TD> 
			<TD width="8%" align="left"><a href="manage_referees_to_game.php?sort=g.gdate&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Game Date</a></TD>
			<TD width="8%" align="left"><a href="manage_referees_to_game.php?sort=g.gtime&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Game Time</a></TD> 				
			<TD width="12%" align="left"><a href="manage_referees_to_game.php?sort=at.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Home Team</a></TD> 
			<TD width="12%" align="left"><a href="manage_referees_to_game.php?sort=ht.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Away Team</a></TD> 
			<TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r1.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Referee</a></TD> 
			<TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r2.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 1</a></TD> 
			<TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r3.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 2</a></TD> 
		  	<TD width="10%" align="center"><span class="style3">Option</span></TD>
              </TR>
          <?php
	  $tr="#f4f4f4";
	  $clr=1;
		while($row = mysql_fetch_object($result))
		{

			if($tr=="#FFFFFF")
			{
				$tr="#efefef";
				$col="#000000";
			}
			else
			{
				$tr="#FFFFFF";
				$col="#000000";
			}
			$tmpid = $row->id ;

			$tmpid = "";

			$agid=$row->id;

        ?>
              <tr bgcolor="<? echo $tr; ?>">
		 <TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->league_name); ?></font></TD>
      	    <TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->dname); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>">
		<? 
			$txtgdate=$row->gdate;
			$txtgdate_arr=explode("-",$txtgdate);
			$txtgdate=$txtgdate_arr[1].'-'.$txtgdate_arr[2].'-'.$txtgdate_arr[0];

		?>
		<? echo stripslashes($txtgdate); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>">
		<? 
			$txtgtime=$row->gtime;
			$txtgtime_arr=explode("-",$txtgtime);
			$txtgtime=$txtgtime_arr[1].'-'.$txtgtime_arr[2].'-'.$txtgtime_arr[0];

		?>
		<? echo stripslashes($txtgtime); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->htname); ?></font></TD>
		<TD  align="left"><font color="<?=$col?>"><? echo stripslashes($row->atname); ?></font></TD>
<TD  align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r1fname).' '.stripslashes($row->r1lname); ?><br><? if($row->main_ref_accept=='P' && $row->main_ref_id!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->main_ref_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->main_ref_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?mainref_id=$agid','test','550','500','true','yes');\">(View Reason)</a>"; ?></font></TD>
<TD  align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r2fname).' '.stripslashes($row->r2lname); ?></font><br><? if($row->r2fname!='') { if($row->ast_ref1_accept=='P' && $row->ast_ref_id1!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->ast_ref1_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->ast_ref1_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?astref_id1=$agid','test','550','500','true','yes');\">(View Reason)</a>"; } ?></TD>
<TD  align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r3fname).' '.stripslashes($row->r3lname); ?></font><br><? if($row->r3fname!='') { if($row->ast_ref2_accept=='P' && $row->ast_ref_id2!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->ast_ref2_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->ast_ref2_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?astref_id2=$agid','test','550','500','true','yes');\">(View Reason)</a>"; } ?></TD>
		    <TD align="center"><input name="button" type="button" class="bttn-s" onClick="location.href='edit_referee_to_game.php?id=<?php echo $row->id; ?>'" value="Edit">
		      <INPUT class="bttn-s" onClick="deleteconfirm('Are you sure you want to delete this Assigned Referee to Game? \n','manage_referees_to_game.php?did=<?php echo($row->id); ?>');" type="button" value="Delete">				</TD>
              </TR>
              <?  
		  		$parentary = NULL ;
		  	}	  ?>
            <input type=hidden name="total" value="<? echo $strTotalNewRow; ?>">
            <TR align=center> 
                <TD colSpan=10>
                <?
		 	if(!$strTotalPerPage)
			{
		 ?>
                  <strong>No Referees To Game Detail Display</strong> 
                  <?
		 	}
		 ?>                </TD>
            </TR>
          </TABLE>
        

        </FORM>
				</TD>
		  </TR>
		</TABLE>
	</td>
  </tr>
</TABLE>
</BODY></HTML>

 

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.