Jump to content

uppercase in dropdown menu

miniu

By miniu
in PHP Coding Help

Recommended Posts

miniu Member

miniu

Posted
Posted

How to make it that the information in the dropdown menu when I am choosing the names that they all will shown as uppercase ? right now the information from the sql are showing like that:

$sql_astref1="select id,fname,lname from referees where '".$gdate2."' NOT BETWEEN fromdate and todate ORDER BY lname";

 

Link to comment
https://forums.phpfreaks.com/topic/195388-uppercase-in-dropdown-menu/
Share on other sites
miniu Member

miniu

Posted
  • Author
Posted

thanx but where should I define it?

<tr>
                              <td width="37%" align="right"><font color="red"></font> Assistant Referee 1:</td>
                              <td width="63%"><font color="<?=$col?>"><select id="astref1" name="astref1" style="width:180px">
						  	<option value="">--Select--</option>
						  <?
						  		$sql_astref1="select id,fname,lname from referees where '".$gdate2."' NOT BETWEEN fromdate and todate ORDER BY lname"; 
								$res_astref1=mysql_query($sql_astref1);
								while($row_astref1=mysql_fetch_object($res_astref1))
								{ ?>
								<option value="<?=$row_astref1->id?>"><?=$row_astref1->lname.' '.$row_astref1->fname?></option>
							<?	}
						  ?>
						  </select>
                              </font></td>
                            </tr>

 

 

  • 2 weeks later...
miniu Member

miniu

Posted
  • Author
Posted

I want to add the uppercase here, but it is not working, why? what should I change?

<select name="drplocations" id="drplocations" style="width:180px">
							<option value="">--Select--</option>
							<? 
								$sql_loc="select * from locations order by lname asc";
								$res_loc=mysql_query($sql_loc);
								while($row_loc=mysql_fetch_object($res_loc))
								{
							?>
							<span style="text-transform:uppercase;"><option value="<?=$row_loc->id;?>" <? if($location_id==$row_loc->id) echo "selected='selected'"; ?>><?=$row_loc->lname;?></option></span>
							<? } ?>
							</select>

 

 

 

miniu Member

miniu

Posted
  • Author
Posted

I don't understand what you mean with "effort" so this is the code to that file:

<?php include("connect.php");
include("admin.session.php");

$LeftLinkSection = 1;
$pagetitle="Game";
$qstr=$_SERVER['QUERY_STRING'];
if($_POST["sub1"]==1)
{
if($_GET["id"])
{
	$currid = $_GET["id"];

	$changed='N';

	$telephone = addslashes($_POST["txttelephone"]);
	$htmanager = addslashes($_POST["txthtmanager"]);
	$ggid = addslashes($_POST["txtid"]);
	$div_id = addslashes($_POST["drpdivision"]);
	$league = addslashes($_POST["drpleague"]);
	$home_team_id= addslashes($_POST["drphometeam"]);
	$away_team_id= addslashes($_POST["drpawayteam"]);

	$gdate = addslashes($_POST["txtdate"]); 
	$kgdate=explode('-',$gdate);
	$gdate=$kgdate[2].'-'.$kgdate[0].'-'.$kgdate[1];

	$time = addslashes($_POST["drptime"]);
	$time2 = addslashes($_POST["drptime2"]);
	$ampm = addslashes($_POST["drpampm"]);
	$location_id= addslashes($_POST["drplocations"]);

	$gtime=$time.':'.$time2.' '.$ampm;

	$sql_check="select gid from assigned_games where gid=".$currid;
	$res_check=mysql_query($sql_check);
	$tot=mysql_num_rows($res_check);

	if($tot > 0)
	{
	//echo $div_id.$_POST['old_drpdivision']; exit;

	if($league!=$_POST['old_drpleague'])
	{
		$changed='Y';
		$sql_lea="select league_name from league where id=".$league;
		$res_lea=mysql_query($sql_lea);
		$row_lea=mysql_fetch_object($res_lea);
		$league_name=$row_lea->league_name;
		$lleague_name="<strong><i><font color=red>".$row_lea->league_name."</font></i></strong>";
	}
	else
	{
		$sql_lea="select league_name from league where id=".$league;
		$res_lea=mysql_query($sql_lea);
		$row_lea=mysql_fetch_object($res_lea);
		$league_name=$row_lea->league_name;
		$lleague_name=$row_lea->league_name;
	}

	if($div_id!=$_POST['old_drpdivision'])
	{
		$changed='Y';
		$sql_div="select dname from divisions where id=".$div_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$dname=$row_div->dname;
		$ddname="<strong><i><font color=red>".$row_div->dname."</font></i></strong>";
	}
	else
	{
		$sql_div="select dname from divisions where id=".$div_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$dname=$row_div->dname;
		$ddname=$row_div->dname;

	}


	if($home_team_id!=$_POST['old_drphometeam'])
	{
		$changed='Y';
		$sql_div="select tname from teams where id=".$home_team_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$htname=$row_div->tname;
		$hhtname="<strong><i><font color=red>".$row_div->tname."</font></i></strong>";
	}
	else
	{
		$sql_div="select tname from teams where id=".$home_team_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$htname=$row_div->tname;
		$hhtname=$row_div->tname;
	}


	if($away_team_id!=$_POST['old_drpawayteam'])
	{
		$changed='Y';
		$sql_div="select tname from teams where id=".$away_team_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$atname=$row_div->tname;
		$aatname="<strong><i><font color=red>".$row_div->tname."</font></i></strong>";
	}
	else
	{
		$sql_div="select tname from teams where id=".$away_team_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$atname=$row_div->tname;
		$aatname=$row_div->tname;

	}


	if($location_id!=$_POST['old_drplocations'])
	{
		$changed='Y';
		$sql_div="select lname,address from locations where id=".$location_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$locname=$row_div->lname;
		$locaddress=$row_div->address;
		$llocname="<strong><i><font color=red>".$row_div->lname."</font></i></strong>";
		$llocaddress="<strong><i><font color=red>".$row_div->address."</font></i></strong>";
	}
	else
	{
		$sql_div="select lname from locations where id=".$location_id;
		$res_div=mysql_query($sql_div);
		$row_div=mysql_fetch_object($res_div);
		$locname=$row_div->lname;
		$locaddress=$row_div->address;
		$llocname=$row_div->lname;
		$llocaddress=$row_div->address;

	}


	if($telephone!=$_POST['old_txttelephone'])
	{
		$changed='Y';
		$telephone=$telephone;
		$ttelephone="<strong><i><font color=red>".$telephone."</font></i></strong>";
	}
	else
	{
		$telephone=$telephone;
		$ttelephone=$telephone;
	}

	if($htmanager!=$_POST['old_txthtmanager'])
	{
		$changed='Y';
		$htmanager=$htmanager;
		$hhtmanager="<strong><i><font color=red>".$htmanager."</font></i></strong>";
	}
	else
	{
		$htmanager=$htmanager;
		$hhtmanager=$htmanager;
	}

	if($_POST["txtdate"]!=$_POST['old_txtdate'])
	{
		$changed='Y';
		$gdate=$gdate;
		$ggdate="<strong><i><font color=red>".$gdate."</font></i></strong>";
	}
	else
		$ggdate=$gdate;

	//echo $time.'test1'.'<br>';
	//echo $_POST['old_drptime'].'test2'.'<br>';


	if(($time!=$_POST['old_drptime']) || ($time2!=$_POST['old_drptime2']) || ($ampm!=$_POST['old_drpampm']) )
	{
		$changed='Y';
		$gtime=$gtime;
		$ggtime="<strong><i><font color=red>".$gtime."</font></i></strong>";
	}
	else
		$ggtime=$gtime;

	}

	$sel="select gid from games where gid='".$ggid."' and id!=".$currid;
	$res=mysql_query($sel);
	if(mysql_num_rows($res) > 0)
	{
		$msg=1;

	}
	else
	{
		if($tot > 0 && $changed=='Y')
		{

		$sql_users="select main_ref_id,ast_ref_id1,ast_ref_id2,assigner_id from assigned_games where gid=".$currid;
		$res_users=mysql_query($sql_users);
		$row_users=mysql_fetch_object($res_users);

		if($row_users->main_ref_id!=0)
		{/*
			$sql_mainref="select fname,lname,email from referees where id=".$row_users->main_ref_id;
			$res_mainref=mysql_query($sql_mainref);
			$row_mainref=mysql_fetch_object($res_mainref);

			$fname=$row_mainref->fname;
			$lname=$row_mainref->lname;
			$email=$row_mainref->email;

			$sql_ass="select phone from assigners where id=".$row_users->assigner_id;
			$res_ass=mysql_query($sql_ass);
			$row_ass=mysql_fetch_object($res_ass);
			$phone=$row_ass->phone;

				$mailcontent="<html><head></head><body>
<table width='80%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr><td colspan='2'> </td></tr>
<tr>
<td width='47%' height='56'>Dear <b>$fname $lname</b>,</td>
<td width='117' align='center' nowrap='nowrap'></td>
</tr>

<tr><td colspan='2'>Following Game Information has been Changed.<br><br>Information those are changed are written in <b>BOLD</b> and <i>ITALIC</i>.</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><strong>Division:</strong> $ddname</td></tr>
<tr><td colspan='2'><strong>Home Team Name:</strong> $hhtname</td></tr>
<tr><td colspan='2'><strong>Away Team Name:</strong> $aatname</td></tr>
<tr><td colspan='2'><strong>Home Team Manager:</strong> $hhtmanager</td></tr>
<tr><td colspan='2'><strong>Telephone:</strong> $ttelephone</td></tr>
<tr><td colspan='2'><strong>Game Date:</strong> $ggdate</td></tr>
<tr><td colspan='2'><strong>Game Time:</strong> $ggtime</td></tr>
<tr><td colspan='2'><strong>Location:</strong> $llocname</td></tr>
<tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'>With the kindest regards,</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><b>Referee Assign System<br><a href='$sitepath' target='_blank'>$sitepath</a></b></td></tr>
</table>
</body>
</html>";

 $to=$email;
 $subject="Following Game Information has been Changed.";
 $from="[email protected]";

 //echo $mailcontent;

@SendHTMLMail1($to,$subject,$mailcontent,$from);

		*/}

		if($row_users->ast_ref_id1!=0)
		{/*
			$sql_mainref="select fname,lname,email from referees where id=".$row_users->ast_ref_id1;
			$res_mainref=mysql_query($sql_mainref);
			$row_mainref=mysql_fetch_object($res_mainref);

			$fname=$row_mainref->fname;
			$lname=$row_mainref->lname;
			$email=$row_mainref->email;

			$sql_ass="select phone from assigners where id=".$row_users->assigner_id;
			$res_ass=mysql_query($sql_ass);
			$row_ass=mysql_fetch_object($res_ass);
			$phone=$row_ass->phone;

				$mailcontent="<html><head></head><body>
<table width='80%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr><td colspan='2'> </td></tr>
<tr>
<td width='47%' height='56'>Dear <b>$fname $lname</b>,</td>
<td width='117' align='center' nowrap='nowrap'></td>
</tr>

<tr><td colspan='2'>Following Game Information has been Changed.<br><br>Information those are changed are written in <b>BOLD</b> and <i>ITALIC</i>.</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><strong>Division:</strong> $ddname</td></tr>
<tr><td colspan='2'><strong>Home Team Name:</strong> $hhtname</td></tr>
<tr><td colspan='2'><strong>Away Team Name:</strong> $aatname</td></tr>
<tr><td colspan='2'><strong>Home Team Manager:</strong> $hhtmanager</td></tr>
<tr><td colspan='2'><strong>Telephone:</strong> $ttelephone</td></tr>
<tr><td colspan='2'><strong>Game Date:</strong> $ggdate</td></tr>
<tr><td colspan='2'><strong>Game Time:</strong> $ggtime</td></tr>
<tr><td colspan='2'><strong>Location:</strong> $llocname</td></tr>
<tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'>With the kindest regards,</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><b>Referee Assign System<br><a href='$sitepath' target='_blank'>$sitepath</a></b></td></tr>
</table>
</body>
</html>";

 $to=$email;
 $subject="Following Game Information has been Changed.";
 $from="[email protected]";

 //echo $mailcontent;

@SendHTMLMail1($to,$subject,$mailcontent,$from);

		*/}

		if($row_users->ast_ref_id2!=0)
		{/*
			$sql_mainref="select fname,lname,email from referees where id=".$row_users->ast_ref_id2;
			$res_mainref=mysql_query($sql_mainref);
			$row_mainref=mysql_fetch_object($res_mainref);

			$fname=$row_mainref->fname;
			$lname=$row_mainref->lname;
			$email=$row_mainref->email;

			$sql_ass="select phone from assigners where id=".$row_users->assigner_id;
			$res_ass=mysql_query($sql_ass);
			$row_ass=mysql_fetch_object($res_ass);
			$phone=$row_ass->phone;

				$mailcontent="<html><head></head><body>
<table width='80%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr><td colspan='2'> </td></tr>
<tr>
<td width='47%' height='56'>Dear <b>$fname $lname</b>,</td>
<td width='117' align='center' nowrap='nowrap'></td>
</tr>

<tr><td colspan='2'>Following Game Information has been Changed.<br><br>Information those are changed are written in <b>BOLD</b> and <i>ITALIC</i>.</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><strong>Division:</strong> $ddname</td></tr>
<tr><td colspan='2'><strong>Home Team Name:</strong> $hhtname</td></tr>
<tr><td colspan='2'><strong>Away Team Name:</strong> $aatname</td></tr>
<tr><td colspan='2'><strong>Home Team Manager:</strong> $hhtmanager</td></tr>
<tr><td colspan='2'><strong>Telephone:</strong> $ttelephone</td></tr>
<tr><td colspan='2'><strong>Game Date:</strong> $ggdate</td></tr>
<tr><td colspan='2'><strong>Game Time:</strong> $ggtime</td></tr>
<tr><td colspan='2'><strong>Location:</strong> $llocname</td></tr>
<tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'>With the kindest regards,</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><b>Referee Assign System<br><a href='$sitepath' target='_blank'>$sitepath</a></b></td></tr>
</table>
</body>
</html>";

 $to=$email;
 $subject="Following Game Information has been Changed.";
 $from="[email protected]";

 //echo $mailcontent;

@SendHTMLMail1($to,$subject,$mailcontent,$from);

		*/}

		if($row_users->assigner_id!='')
		{
			$sql_mainref="select fname,lname,email from assigners where id=".$row_users->assigner_id;
			$res_mainref=mysql_query($sql_mainref);
			$row_mainref=mysql_fetch_object($res_mainref);

			$fname=$row_mainref->fname;
			$lname=$row_mainref->lname;
			$email=$row_mainref->email;

			$sql_ass="select phone from assigners where id=".$row_users->assigner_id;
			$res_ass=mysql_query($sql_ass);
			$row_ass=mysql_fetch_object($res_ass);
			$phone=$row_ass->phone;

				$mailcontent="<html><head></head><body>
<table width='80%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr><td colspan='2'> </td></tr>
<tr>
<td width='47%' height='56'>Dear <b>$fname $lname</b>,</td>
<td width='117' align='center' nowrap='nowrap'></td>
</tr>

<tr><td colspan='2'>Following Game Information has been Changed.<br><br>Information those are changed are written in <b>BOLD</b>, <i>ITALIC</i> and marked as <font color=red> RED </font>.</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><strong>League:</strong> $lleague_name</td></tr>
<tr><td colspan='2'><strong>Division:</strong> $ddname</td></tr>
<tr><td colspan='2'><strong>Home Team Name:</strong> $hhtname</td></tr>
<tr><td colspan='2'><strong>Away Team Name:</strong> $aatname</td></tr>
<tr><td colspan='2'><strong>Home Team Manager:</strong> $hhtmanager</td></tr>
<tr><td colspan='2'><strong>Telephone:</strong> $ttelephone</td></tr>
<tr><td colspan='2'><strong>Game Date:</strong> $ggdate</td></tr>
<tr><td colspan='2'><strong>Game Time:</strong> $ggtime</td></tr>
<tr><td colspan='2'><strong>Location:</strong> $llocname</td></tr>
<tr><td colspan='2'><strong>Location Address:</strong> $llocaddress</td></tr>
<tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><u>To see more details please login to your account</u></td></tr>
<tr><td colspan='2'>With the kindest regards,</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><b>Referee Assign System<br><a href='$sitepath' target='_blank'>$sitepath</a></b></td></tr>
</table>
</body>
</html>";

 $to=$email;
 $subject="GAME CHANGED: $ggdate $hhtname vs $aatname";
 $from="[email protected]";

//echo $mailcontent;

@SendHTMLMail1($to,$subject,$mailcontent,$from);

		}

		}

//exit;

	$que="UPDATE games set 
			div_id=$div_id,
			league_id=$league,
			home_team_id=$home_team_id,
			away_team_id=$away_team_id,
			htmanager='$htmanager',
			telephone='$telephone',
			gdate='$gdate',
			gtime='$gtime',
			location_id='$location_id' 
			where id=$currid";
		$run=mysql_query($que);
		echo mysql_error();
		header('location:message.php?mid=2');
  }

}
else
{
	$telephone = addslashes($_POST["txttelephone"]);
	$htmanager = addslashes($_POST["txthtmanager"]);

	$ggid = addslashes($_POST["txtid"]);
	$div_id = addslashes($_POST["drpdivision"]);
	$league = addslashes($_POST["drpleague"]);
	$home_team_id= addslashes($_POST["drphometeam"]);
	$away_team_id= addslashes($_POST["drpawayteam"]);
	$gid = addslashes($_POST["txtid"]);

	$gdate = addslashes($_POST["txtdate"]); 
	$kgdate=explode('-',$gdate);
	$gdate=$kgdate[2].'-'.$kgdate[0].'-'.$kgdate[1];


	$time = addslashes($_POST["drptime"]);
	$time2 = addslashes($_POST["drptime2"]);
	$ampm = addslashes($_POST["drpampm"]);
	$location_id= addslashes($_POST["drplocations"]);

	$gtime=$time.':'.$time2.' '.$ampm;

	$sel="select gid from games where gid='".$ggid."'";
	$res=mysql_query($sel);
	if(mysql_num_rows($res) > 0)
	{
		$msg=1;

	}
	else
	{

	$que="insert into games set 
			div_id=$div_id,
			league_id=$league,
			home_team_id=$home_team_id,
			away_team_id=$away_team_id,
			htmanager='$htmanager',
			telephone='$telephone',
			gdate='$gdate',
			gtime='$gtime',
			location_id='$location_id'";

		$run=mysql_query($que);

		$gid=mysql_insert_id();

		$que2="update games set gid='$gid' where id=".$gid;
		mysql_query($que2);

		echo mysql_error();
		header('location:message.php?mid=1');
  }

}

}
if($_GET["id"])
{
//DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
$selsql= "select * from games where id=".$_GET["id"]  ;
$selres = mysql_query($selsql);
$selobj = mysql_fetch_object($selres);

$league = stripslashes($selobj->league_id);
$div_id = stripslashes($selobj->div_id);
$home_team_id = stripslashes($selobj->home_team_id);
$away_team_id = stripslashes($selobj->away_team_id);

$htmanager = stripslashes($selobj->htmanager);
$telephone = stripslashes($selobj->telephone);

$gid = stripslashes($selobj->gid);
$lastid = stripslashes($selobj->gid);

$gdate = stripslashes($selobj->gdate);
$kgdate=explode('-',$gdate);
$gdate=$kgdate[1].'-'.$kgdate[2].'-'.$kgdate[0];

$gtime = stripslashes($selobj->gtime);

$htime=explode(':',$gtime);

$ampm=explode(' ',$htime[1]);

$location_id = stripslashes($selobj->location_id);




}
else
{
$sql_maxid="select max(id) as maxid from games";
$res_maxid=mysql_query($sql_maxid);
$row_maxid=mysql_fetch_array($res_maxid);
$lastid=$row_maxid[0];
$lastid++;


}

if($_GET['divid']!='')
$div_id=$_GET['divid'];

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

if($_GET['tid']!='')
{
$sql_team="select htmanager,phone from teams where id=".$_GET['tid'];
$res_team=mysql_query($sql_team);
$row_team=mysql_fetch_object($res_team);
$htmanager = stripslashes($row_team->htmanager);
$telephone = stripslashes($row_team->phone);
$home_team_id=$_GET['tid'];

}



?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD><title><?=Site_Title; ?></title>
<script language="javascript">
function kyb_check()
{
if(document.getElementById("drpleague").value=="")
{
	alert("Please Select League");
	document.getElementById("drpleague").focus();
	return false;
}

if(document.getElementById("drpdivision").value=="")
{
	alert("Please Select Division");
	document.getElementById("drpdivision").focus();
	return false;
}
if(document.getElementById("drphometeam").value=="")
{
	alert("Please Select Home Team");
	document.getElementById("drphometeam").focus();
	return false;
}
if(document.getElementById("drpawayteam").value=="")
{
	alert("Please Select Away Team");
	document.getElementById("drpawayteam").focus();
	return false;
}
if(document.getElementById("drphometeam").value==document.getElementById("drpawayteam").value)
{
	alert("Home Team and Away Team can not be Same.");
	document.getElementById("drpawayteam").focus();
	return false;

}
if(document.getElementById("txthtmanager").value=="")
{
	alert("Please Enter Home Team Manager");
	document.getElementById("txthtmanager").focus();
	return false;
}
if(document.getElementById("txttelephone").value=="")
{
	alert("Please Enter Telephone");
	document.getElementById("txttelephone").focus();
	return false;
}
if(document.getElementById("txtdate").value=="")
{
	alert("Please Select Game Date");
	document.getElementById("txtdate").focus();
	return false;
}
if(document.getElementById("drptime").value=="")
{
	alert("Please Select Hours");
	document.getElementById("drptime").focus();
	return false;
}
if(document.getElementById("drptime2").value=="")
{
	alert("Please Select Minutes");
	document.getElementById("drptime2").focus();
	return false;
}
if(document.getElementById("drplocations").value=="")
{
	alert("Please Select Locations");
	document.getElementById("drplocations").focus();
	return false;
}

}
function showteams(val)
{
window.location.href="add_game.php?divid=" + val + "&id=" + document.getElementById('id').value + "&league_id=" + document.getElementById('drpleague').value;

}
function show_manager(val,divid)
{
window.location.href="add_game.php?divid=" + divid + "&id=" + document.getElementById('id').value + "&tid=" + val + "&league_id=" + document.getElementById('drpleague').value;
}
function show_divisions(val)
{
window.location.href='add_game.php?league_id=' + val + '&htmanager=' + document.getElementById('txthtmanager').value + '&telephone=' + document.getElementById('txttelephone').value + '&id=' + document.getElementById('id').value;
}

</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">
</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   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" height="480" bgcolor="#FFFFFF">
		<TABLE  cellSpacing=0 cellPadding=0  border=0 width="90%" align="center">
			<TR><TD width="100%"  class=h1> </TD></TR>
			<TR><TD width="100%"  class=H1><? echo ($_GET["id"]>0)?"Edit":"Add"; ?> <?=$pagetitle?></TD></TR>
			<TR><TD background="images/vdots.gif"></TD></TR>
			<? if($msg==1) { ?>
			<tr><td class="error" height="30"><font color="red"><strong>Game ID Already Exist!</strong></font></td></tr>
			<? } ?>
			<TR>
				<TD>
					<form method="post" enctype="multipart/form-data" name="frm">
					  <table width="90%" border="0" align="left" cellpadding="3" cellspacing="3" class="solidinput">
                            <tr>
                              <td colspan="2" align="right" class="menu-a"><span class="a-l">* indicates required field</span>  </td>
                            </tr>
                            <tr>
                              <td class="H4" colspan="2" align="left"><?=$pagetitle?>
                                Information </td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Game ID:</td>
                              <td width="63%"><font color="<?=$col?>"><?=$lastid?>
                              </font></td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> League Name:</td>
                              <td width="63%"><font color="<?=$col?>"><select name="drpleague" id="drpleague" style="width:180px" 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>
                            
                              </font></td>
                            </tr>
						<? if(!isset($_GET['league_id'])) { ?>
							<input type="hidden" id="old_drpleague" name="old_drpleague" value="<?=$league?>">
							<? } ?>
						<? if($league!='') { ?>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Division:</td>
                              <td width="63%"><font color="<?=$col?>">
                                <select name="drpdivision" id="drpdivision" style="width:180px" onChange="showteams(this.value)">
							<option value="">--Select--</option>
							<? 
								$sql_div="select * from divisions where league_id=".$league." order by dname";
								$res_div=mysql_query($sql_div);
								while($row_div=mysql_fetch_object($res_div))
								{
							?>
							<option value="<?=$row_div->id;?>" <? if($div_id==$row_div->id) echo "selected='selected'"; ?>><?=$row_div->dname;?></option>
							<? } ?>
							</select>
							<? if(!isset($_GET['divid'])) { ?>
							<input type="hidden" id="old_drpdivision" name="old_drpdivision" value="<?=$div_id?>">
							<? } ?>
                              </font></td>
                            </tr>
						<? } ?>
						<? if($div_id!='') { ?>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Home Team:</td>
                              <td width="63%"><font color="<?=$col?>">
       <select name="drphometeam" id="drphometeam" style="width:180px" onChange="show_manager(this.value,'<?=$_GET['divid']?>')">
							<option value="">--Select--</option>
							<? 
								$sql_home_team="select * from teams where div_id=".$div_id." order by tname";
								$res_home_team=mysql_query($sql_home_team);
								while($row_home_team=mysql_fetch_object($res_home_team))
								{
							?>
							<option value="<?=$row_home_team->id;?>" <? if($home_team_id==$row_home_team->id) echo "selected='selected'"; ?>><?=$row_home_team->tname;?></option>
							<? } ?>
							</select>
                              </font>
							<input type="hidden" id="old_drphometeam" name="old_drphometeam" value="<?=$home_team_id?>">
						  </td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Away Team:</td>
                              <td width="63%"><font color="<?=$col?>">
                                <select name="drpawayteam" id="drpawayteam" style="width:180px">
							<option value="">--Select--</option>
							<? 
								$sql_away_team="select * from teams where div_id=".$div_id." order by tname";
								$res_away_team=mysql_query($sql_away_team);
								while($row_away_team=mysql_fetch_object($res_away_team))
								{
							?>
							<option value="<?=$row_away_team->id;?>" <? if($away_team_id==$row_away_team->id) echo "selected='selected'"; ?>><?=$row_away_team->tname;?></option>
							<? } ?>
							</select>
                              </font>
						  <input type="hidden" id="old_drpawayteam" name="old_drpawayteam" value="<?=$away_team_id?>">
						  </td>
                            </tr>
						<? } ?>
						<tr>
                              <td width="37%" align="right"><font color="red"></font> Home Team Manager:</td>
                              <td width="63%"><font color="<?=$col?>"><?=$htmanager?>
                                <input type="hidden" name="txthtmanager" id="txthtmanager" size="40" value="<?=stripslashes($htmanager);?>"><input type="hidden" id="old_txthtmanager" name="old_txthtmanager" value="<?=$htmanager?>">
                              </font></td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red"></font> Telephone:</td>
                              <td width="63%"><font color="<?=$col?>"><?=$telephone?>
                                <input type="hidden" name="txttelephone" id="txttelephone" size="40" value="<?=stripslashes($telephone);?>"><input type="hidden" id="old_txttelephone" name="old_txttelephone" value="<?=$telephone?>">
                              </font></td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Date: </td>
                              <td width="63%"><font color="<?=$col?>">
                                <input type="text" readonly="true" name="txtdate" id="txtdate" size="20" value="<?=stripslashes($gdate);?>"> <a href="#" onClick="getCalendar(document.getElementById('txtdate'));">Select Date</a>
                              </font><input type="hidden" id="old_txtdate" name="old_txtdate" value="<?=$gdate?>"></td>
                            </tr>
						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Time: </td>
                              <td width="63%"><font color="<?=$col?>">
                                <select name="drptime" id="drptime">
							<option value="">Hrs</option>
							<option value="01" <? if($htime[0]=='01') echo "selected='selected'"; ?>>01</option>
							<option value="02" <? if($htime[0]=='02') echo "selected='selected'"; ?>>02</option>
							<option value="03" <? if($htime[0]=='03') echo "selected='selected'"; ?>>03</option>
							<option value="04" <? if($htime[0]=='04') echo "selected='selected'"; ?>>04</option>
							<option value="05" <? if($htime[0]=='05') echo "selected='selected'"; ?>>05</option>
							<option value="06" <? if($htime[0]=='06') echo "selected='selected'"; ?>>06</option>
							<option value="07" <? if($htime[0]=='07') echo "selected='selected'"; ?>>07</option>
							<option value="08" <? if($htime[0]=='08') echo "selected='selected'"; ?>>08</option>
							<option value="09" <? if($htime[0]=='09') echo "selected='selected'"; ?>>09</option>
							<option value="10" <? if($htime[0]=='10') echo "selected='selected'"; ?>>10</option>
							<option value="11" <? if($htime[0]=='11') echo "selected='selected'"; ?>>11</option>
							<option value="12" <? if($htime[0]=='12') echo "selected='selected'"; ?>>12</option>
							</select>
							<input type="hidden" id="old_drptime" name="old_drptime" value="<?=$htime[0]?>">
							<select name="drptime2" id="drptime2">
							<option value="">Min</option>
							<? for($i=0;$i<=59;$i++) { ?>
							<? if($i<=9) { ?>
				<option value="<?='0'.$i?>" <? if($ampm[0]=='0'.$i) echo "selected='selected'"; ?>><?='0'.$i;?></option>
							<? } else { ?>
							<option value="<?=$i?>" <? if($ampm[0]==$i) echo "selected='selected'"; ?>><?=$i;?></option>
							<? } ?>
							<? } ?>
							</select>
							<input type="hidden" id="old_drptime2" name="old_drptime2" value="<?=$ampm[0]?>">
							 <select name="drpampm" id="drpampm">
							<option value="AM" <? if($ampm[1]=='AM') echo "selected='selected'"; ?>>AM</option>
							<option value="PM" <? if($ampm[1]=='PM') echo "selected='selected'"; ?>>PM</option>
							</select>
							<input type="hidden" id="old_drpampm" name="old_drpampm" value="<?=$ampm[0]?>">
                              </font></td>
                            </tr>

						<tr>
                              <td width="37%" align="right"><font color="red">*</font> Location: </td>
                              <td width="63%"><font color="<?=$col?>">
                                <select name="drplocations" id="drplocations" style="width:180px">
							<option value="">--Select--</option>
							<? 
								$sql_loc="select * from locations order by lname asc";
								$res_loc=mysql_query($sql_loc);
								while($row_loc=mysql_fetch_object($res_loc))
								{
							?>
							<span style="text-transform:uppercase;"><option value="<?=$row_loc->id;?>" <? if($location_id==$row_loc->id) echo "selected='selected'"; ?>><?=$row_loc->lname;?></option></span>
							<? } ?>
							</select>
                              </font>
						  <input type="hidden" id="old_drplocations" name="old_drplocations" value="<?=$location_id?>">
						  </td>
                            </tr>

                            <tr>
                              <td> 
                                  <input type="hidden" value="<?=$_GET["id"]; ?>" id="id" name="id"></td>
                              <td><input name="Submit" type="submit" class="buttonclass" value="Submit" onClick="return kyb_check();" /></td>
                              <input type="hidden" name="sub1" value="1">
                            </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.