uppercase in dropdown menu

miniu · March 16, 2010

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";

LeadingWebDev · March 16, 2010

strtoupper();

miniu · March 16, 2010

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>

trq · March 16, 2010

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

miniu · March 26, 2010

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>

trq · March 27, 2010

Its not working because its not in your code. Post your code where you actually make an effort.

miniu · March 27, 2010

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="no-reply@njsa-assignments.com";

 //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="no-reply@njsa-assignments.com";

 //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="no-reply@njsa-assignments.com";

 //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="no-reply@njsa-assignments.com";

//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>

trq · March 27, 2010

Now, where amongst all that code is your problematic code?

Sign In

uppercase in dropdown menu

Recommended Posts

miniu

Link to comment

Share on other sites

LeadingWebDev

Link to comment

Share on other sites

miniu

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

miniu

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

miniu

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information