miniu Posted March 16, 2010 Share Posted 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"; Quote Link to comment Share on other sites More sharing options...
LeadingWebDev Posted March 16, 2010 Share Posted March 16, 2010 strtoupper(); Quote Link to comment Share on other sites More sharing options...
miniu Posted March 16, 2010 Author Share Posted 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> Quote Link to comment Share on other sites More sharing options...
trq Posted March 16, 2010 Share Posted March 16, 2010 $sql_astref1="select id,UPPER(fname),UPPER(lname) from referees where '".$gdate2."' NOT BETWEEN fromdate and todate ORDER BY lname"; Quote Link to comment Share on other sites More sharing options...
miniu Posted March 26, 2010 Author Share Posted 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> Quote Link to comment Share on other sites More sharing options...
trq Posted March 27, 2010 Share Posted March 27, 2010 Its not working because its not in your code. Post your code where you actually make an effort. Quote Link to comment Share on other sites More sharing options...
miniu Posted March 27, 2010 Author Share Posted 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> Quote Link to comment Share on other sites More sharing options...
trq Posted March 27, 2010 Share Posted March 27, 2010 Now, where amongst all that code is your problematic code? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.