miniu Posted March 15, 2010 Share Posted March 15, 2010 I have a little problem. I made a selection from the database. It is getting me list of games to be assigned by referees. But when I choose the option "Games with NO REFEREE Assigned" it didn't show me that. He displays the same window. here is the php code <td width="100%" colspan="2" align="left"><select id="refsel" name="refsel"> <div class="noprint"><option value="" <? if($_POST['refsel']==' ') echo "selected='selected'"; ?>>--Select--</option></div> <div class="noprint"><option value="0" <? if($_POST['refsel']!='') { if($_POST['refsel']==0) echo "selected='selected'"; } ?>>Games with NO REFEREE Assigned</option></div> <div class="noprint"><option value="1" <? if($_POST['refsel']==1) echo "selected='selected'"; ?>>Games with NO Main Referee Assigned</option></div> <div class="noprint"><option value="2" <? if($_POST['refsel']==2) echo "selected='selected'"; ?>>Games with NO Assistant Referee 1 Assigned</option></div> <div class="noprint"><option value="3" <? if($_POST['refsel']==3) echo "selected='selected'"; ?>>Games with NO Assistant Referee 2 Assigned</option></div> </select> <select name="drpleague" id="drpleague" style="width:150px" onChange="show_divisions(this.value)"> and here is the sql for that defined in the same file: if($_POST['refsel']!='') { if($_POST['refsel']==0) { $strQueryPerPage.=" and ag.main_ref_id=0 and ag.ast_ref_id1=0 and ag.ast_ref_id2=0"; } if($_POST['refsel']==1) { $strQueryPerPage.=" and ag.main_ref_id=0"; } if($_POST['refsel']==2) { $strQueryPerPage.=" and ag.ast_ref_id1=0"; } if($_POST['refsel']==3) { $strQueryPerPage.=" and ag.ast_ref_id2=0"; } } what am I doing wrong? Link to comment https://forums.phpfreaks.com/topic/195315-select-from-database-what-am-i-doing-wrong/ Share on other sites More sharing options...
Rifts Posted March 15, 2010 Share Posted March 15, 2010 where is your $result = mysql_query("SELECT * FROM example") line Link to comment https://forums.phpfreaks.com/topic/195315-select-from-database-what-am-i-doing-wrong/#findComment-1026511 Share on other sites More sharing options...
miniu Posted March 15, 2010 Author Share Posted March 15, 2010 That's the code <?php include("connect.php"); include("admin.session.php"); $LeftLinkSection = 1; $pagetitle="Referees To Game"; if(isset($_GET['did'])) { $sql="delete from assigned_games where id=".$_GET['did']; $res=mysql_query($sql); echo mysql_error(); header('location:message.php?mid=27'); } if($_POST['sub11']==1) { //echo 'ts'; } if($_GET['league_id']!='') $league=$_GET['league_id']; ?> <HTML> <HEAD><title><?=Site_Title; ?></title> <SCRIPT language="javascript" src="body.js"></SCRIPT> <script> function show_divisions(val) { window.location.href='manage_referees_to_game.php?league_id=' + val; } function show_getgames() { if(document.getElementById('txtfromdate').value!='' && document.getElementById('txttodate').value=='') { alert('Please Select To Date'); document.getElementById('txttodate').focus(); return false; } if(document.getElementById('txttodate').value!='' && document.getElementById('txtfromdate').value=='') { alert('Please Select From Date'); document.getElementById('txtfromdate').focus(); return false; } if(document.getElementById('txttodate').value < document.getElementById('txtfromdate').value) { alert('To Date can not be less then From Date'); document.getElementById('txttodate').focus(); return false; } document.getElementById('sub11').value=1; document.frmgetgames.submit(); } function clearall() { document.getElementById('txtfromdate').value=''; document.getElementById('txttodate').value=''; document.getElementById('refsel').value=''; document.getElementById('drpdivisions').value=''; } function openWin(pageToLoad, winName, width, height, center,scrollbar){ if ((parseInt(navigator.appVersion) >= 4 ) && (center)){ xposition = (screen.width - width) / 2; yposition = (screen.height - height - 100) / 2; args = "width=" + width + "," + "height=" + height + "," + "location=0," + "menubar=0," + "resizable=no," + "scrollbars=" + scrollbar + "," + "status=0," + "titlebar=0," + "toolbar=0," + "hotkeys=0," + "screenx=" + xposition + "," + "screeny=" + yposition + "," + "left=" + xposition + "," + "top=" + yposition; newWindow = window.open(pageToLoad,winName,args); window.focus; } } </script> <script src="calendar.js"></script> <META http-equiv=Content-Type content="text/html; charset=utf-8"> <META content="MSHTML 6.00.2600.0" name=GENERATOR> <link rel="stylesheet" href="main.css" type="text/css"> <style type="text/css"> <!-- .style3 {color: #FFFFFF} --> </style> <style type="text/css"> /* media neutral styles go here */ @media print { .noprint { display: none; } } </style> </HEAD> <BODY leftMargin=0 topMargin=0 marginheight="0" marginwidth="0"> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 class="th-a"> <TR><TD height=60 valign="top" colspan="2" bgColor="#ffffff"><div class="noprint"><? include("top.php") ?></div></td></TR> <tr> <td width="20%" valign="top" bgcolor="#1c6995"><div class="noprint"><? include("left.php"); ?></div></td> <td width="80%" valign="top" bgcolor="#FFFFFF" height="480"> <TABLE width="97%" border=0 cellPadding=0 cellSpacing=0 align="center"> <TR><TD width="100%" class="H1"><div class="noprint"> </div></TD></TR> <TR><TD align="center" width="100%" class="a-l"><div class="noprint"><?php echo $Message2 ; ?></div></TD></TR> <TR> <div class="noprint"><? if($msg!="") { ?></div> <TR><TD align="center" width="100%" class="a-l"><font color="red"><b><div class="noprint">User Deleted Successfully</div></b></font></TD></TR> <TR> <? } ?> <TD width="100%" class="H1"><div class="noprint">Manage <?=$pagetitle?></div></TD> </TR> <TR><TD background="images/vdots.gif"><div class="noprint"><IMG height=1 src="images/spacer.gif" width=1 border=0></div></TD></TR> <tr> <TD> <div class="noprint"><FORM name="order" action="#" method="post"></div> <TABLE cellSpacing=0 cellPadding=1 border=0 > <tr><td colspan="25" height="20"><div class="noprint"><b>View By Main Referee Name</b></div></td></tr> <div class="noprint"><?=$prs_pageing->order();?></div> </TABLE> </form> <br><div class="noprint"><form name="frmgetgames" id="frmgetgames" method="post"></div> <div class="noprint"><table cellpadding="0" cellspacing="0" border="0"> <td width="100%" colspan="2" align="left"><select id="refsel" name="refsel"> <div class="noprint"><option value="" <? if($_POST['refsel']==' ') echo "selected='selected'"; ?>>--Select--</option></div> <div class="noprint"><option value="0" <? if($_POST['refsel']!='') { if($_POST['refsel']==0) echo "selected='selected'"; } ?>>Games with NO REFEREE Assigned</option></div> <div class="noprint"><option value="1" <? if($_POST['refsel']==1) echo "selected='selected'"; ?>>Games with NO Main Referee Assigned</option></div> <div class="noprint"><option value="2" <? if($_POST['refsel']==2) echo "selected='selected'"; ?>>Games with NO Assistant Referee 1 Assigned</option></div> <div class="noprint"><option value="3" <? if($_POST['refsel']==3) echo "selected='selected'"; ?>>Games with NO Assistant Referee 2 Assigned</option></div> </select> <select name="drpleague" id="drpleague" style="width:150px" onChange="show_divisions(this.value)"> <div class="noprint"><option value="">--Select--</option></div> <div class="noprint"><? $sql_league="select * from league"; $res_league=mysql_query($sql_league); while($row_league=mysql_fetch_object($res_league)) { ?></div> <div class="noprint"><option value="<?=$row_league->id?>" <? if($row_league->id==$league) echo "selected='selected'"; ?>><?=stripslashes($row_league->league_name)?></option></div> <? } ?> </select> <? if($league!='') { ?><div class="noprint"><select id="drpdivisions" name="drpdivisions"></div> <div class="noprint"><option value="">--Select Division--</option></div> <? $sql_division="select * from divisions where league_id=".$league." order by dname"; $res_division=mysql_query($sql_division); while($row_division=mysql_fetch_object($res_division)) { ?> <div class="noprint"><option value="<?=$row_division->id?>" <? if($_POST['drpdivisions']==$row_division->id) echo "selected='selected'"; ?>><?=stripslashes($row_division->dname);?></option></div> <? } ?> </select><? } ?> </td></tr> <tr> <td width="100%" colspan="2" align="center"><div class="noprint"> From Date: </div><input type="text" name="txtfromdate" readonly="true" id="txtfromdate" size="15" value="<?=stripslashes($_REQUEST['txtfromdate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txtfromdate'));"> Select Date</a> To Date: <input type="text" name="txttodate" readonly="true" id="txttodate" size="15" value="<?=stripslashes($_REQUEST['txttodate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txttodate'));"> Select Date</a> <input type="button" value="Get Games" onClick="show_getgames();"><input type="hidden" id="sub11" name="sub11" value="0"> <input type="button" value="Clear" onClick="clearall();"> </td> </tr> <tr><td colspan="2"> </td></tr> <tr> </table></form><br> <? if($_GET["order"]) { $order=$_GET["order"]; $strQueryPerPage="select lea.league_name,ht.tname as htname,at.tname as atname,d.dname,g.gdate,g.gtime,ag.id,ag.gid,ag.main_ref_id,ag.ast_ref_id1,ag.ast_ref_id2,ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,r1.fname as r1fname,r1.lname as r1lname,r2.fname as r2fname,r2.lname as r2lname,r3.fname as r3fname,r3.lname as r3lname from assigned_games ag left outer join referees r1 on ag.main_ref_id=r1.id left outer join referees r2 on ag.ast_ref_id1=r2.id left outer join referees r3 on ag.ast_ref_id2=r3.id left outer join games g on ag.gid=g.gid left outer join divisions d on g.div_id=d.id left outer join league lea on g.league_id=lea.id left outer join teams ht on g.home_team_id=ht.id left outer join teams at on g.away_team_id=at.id where r1.fname like '$order%'"; } else $strQueryPerPage="select lea.league_name,ht.tname as htname,at.tname as atname,d.dname,g.gdate,g.gtime,ag.main_ref_id,ag.ast_ref_id1,ag.ast_ref_id2,ag.id,ag.gid,ag.main_ref_accept,ag.ast_ref1_accept,ag.ast_ref2_accept,r1.fname as r1fname,r1.lname as r1lname,r2.fname as r2fname,r2.lname as r2lname,r3.fname as r3fname,r3.lname as r3lname from assigned_games ag left outer join referees r1 on ag.main_ref_id=r1.id left outer join referees r2 on ag.ast_ref_id1=r2.id left outer join referees r3 on ag.ast_ref_id2=r3.id left outer join games g on ag.gid=g.gid left outer join divisions d on g.div_id=d.id left outer join league lea on g.league_id=lea.id left outer join teams ht on g.home_team_id=ht.id left outer join teams at on g.away_team_id=at.id where 1=1"; //echo $strQueryPerPage; if($_POST['sub11']==1) { if($_REQUEST['txtfromdate']!='') { $txtfromdate=$_REQUEST['txtfromdate']; $txtfromdate_arr=explode("-",$txtfromdate); $txtfromdate=$txtfromdate_arr[2].'-'.$txtfromdate_arr[0].'-'.$txtfromdate_arr[1]; $txttodate=$_REQUEST['txttodate']; $txttodate_arr=explode("-",$txttodate); $txttodate=$txttodate_arr[2].'-'.$txttodate_arr[0].'-'.$txttodate_arr[1]; $strQueryPerPage.=" and g.gdate >='".$txtfromdate."' and g.gdate<='".$txttodate."'"; } if($_POST['refsel']!='') { if($_POST['refsel']==0) { $strQueryPerPage.=" and ag.main_ref_id=0 and ag.ast_ref_id1=0 and ag.ast_ref_id2=0"; } if($_POST['refsel']==1) { $strQueryPerPage.=" and ag.main_ref_id=0"; } if($_POST['refsel']==2) { $strQueryPerPage.=" and ag.ast_ref_id1=0"; } if($_POST['refsel']==3) { $strQueryPerPage.=" and ag.ast_ref_id2=0"; } } if($_POST['drpdivisions']!='') { $strQueryPerPage.=" and d.id=".$_POST['drpdivisions']; $drp_division=$_POST['drpdivisions']; } if($_POST['drpleague']!='') { $strQueryPerPage.=" and lea.id=".$_POST['drpleague']; $league=$_POST['drpleague']; } } if(isset($_GET['sort'])) $strQueryPerPage.=" order by ".$_GET['sort']." ".$_GET['ordby']; else $strQueryPerPage.=" order by ag.id desc"; //echo $strQueryPerPage; $strResultPerPage=mysql_query($strQueryPerPage); $strTotalPerPage=mysql_affected_rows(); ?> <FORM name="form2" action="#" method="post"> <td align="right"><a href="#" onClick="javascript:window.print();"><div class="noprint"><b>PRINT</b></div></a> </td> <TABLE width="100%" height="89" border=1 cellSpacing=0 class=t-a> <!--DWLayoutTable--> <TBODY> <TR class="th-a"> <TD colspan="10"> <div class="noprint"><? $result=$prs_pageing->number_pageing($strQueryPerPage,15,7); ?> </div> </TD> </TR> <TR class=th-a> <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=lea.league_name&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">League Name</a></TD> <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=d.dname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Division</a></TD> <TD width="8%" align="left"><a href="manage_referees_to_game.php?sort=g.gdate&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Game Date</a></TD> <TD width="8%" align="left"><a href="manage_referees_to_game.php?sort=g.gtime&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Game Time</a></TD> <TD width="12%" align="left"><a href="manage_referees_to_game.php?sort=at.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Home Team</a></TD> <TD width="12%" align="left"><a href="manage_referees_to_game.php?sort=ht.tname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Away Team</a></TD> <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r1.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Referee</a></TD> <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r2.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 1</a></TD> <TD width="10%" align="left"><a href="manage_referees_to_game.php?sort=r3.fname&<? if($_GET['ordby']=='asc' || $_GET['ordby']=='' ) {?>ordby=desc<? } else {?>ordby=asc<? } ?>" class="link2">Assistant Referee 2</a></TD> <TD width="10%" align="center"><span class="style3"><div class="noprint">Option</div></span></TD> </TR> <?php $tr="#f4f4f4"; $clr=1; while($row = mysql_fetch_object($result)) { if($tr=="#FFFFFF") { $tr="#efefef"; $col="#000000"; } else { $tr="#FFFFFF"; $col="#000000"; } $tmpid = $row->id ; $tmpid = ""; $agid=$row->id; ?> <tr bgcolor="<? echo $tr; ?>"> <TD align="left"><font color="<?=$col?>"><? echo stripslashes($row->league_name); ?></font></TD> <TD align="left"><font color="<?=$col?>"><? echo stripslashes($row->dname); ?></font></TD> <TD align="left"><font color="<?=$col?>"> <? $txtgdate=$row->gdate; $txtgdate_arr=explode("-",$txtgdate); $txtgdate=$txtgdate_arr[1].'-'.$txtgdate_arr[2].'-'.$txtgdate_arr[0]; ?> <? echo stripslashes($txtgdate); ?></font></TD> <TD align="left"><font color="<?=$col?>"> <? $txtgtime=$row->gtime; $txtgtime_arr=explode("-",$txtgtime); $txtgtime=$txtgtime_arr[1].'-'.$txtgtime_arr[2].'-'.$txtgtime_arr[0]; ?> <? echo stripslashes($txtgtime); ?></font></TD> <TD align="left"><font color="<?=$col?>"><? echo stripslashes($row->htname); ?></font></TD> <TD align="left"><font color="<?=$col?>"><? echo stripslashes($row->atname); ?></font></TD> <TD align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r1fname).' '.stripslashes($row->r1lname); ?><br><? if($row->main_ref_accept=='P' && $row->main_ref_id!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->main_ref_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->main_ref_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?mainref_id=$agid','test','550','500','true','yes');\">(View Reason)</a>"; ?></font></TD> <TD align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r2fname).' '.stripslashes($row->r2lname); ?></font><br><? if($row->r2fname!='') { if($row->ast_ref1_accept=='P' && $row->ast_ref_id1!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->ast_ref1_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->ast_ref1_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?astref_id1=$agid','test','550','500','true','yes');\">(View Reason)</a>"; } ?></TD> <TD align="left"><font color="<?=$col?>"> <? echo stripslashes($row->r3fname).' '.stripslashes($row->r3lname); ?></font><br><? if($row->r3fname!='') { if($row->ast_ref2_accept=='P' && $row->ast_ref_id2!=0) echo "<font color='#FF9900'><b>Pending</b></font>"; ?><? if($row->ast_ref2_accept=='A') echo "<font color='#006633'><b>Accepted</b></font>"; ?><? if($row->ast_ref2_accept=='R') echo "<font color='#FF0000'><b>Rejected</b></font><a href='#' onclick=\"openWin('view_reason.php?astref_id2=$agid','test','550','500','true','yes');\">(View Reason)</a>"; } ?></TD> <TD align="center"><div class="noprint"><input name="button" type="button" class="bttn-s" onClick="location.href='edit_referee_to_game.php?id=<?php echo $row->id; ?>'" value="Edit Assignment"></div> <div class="noprint"><INPUT class="bttn-s" onClick="deleteconfirm('Are you sure you want to delete this Assigned Referee to Game? \n','manage_referees_to_game.php?did=<?php echo($row->id); ?>');" type="button" value="Delete Assignment"></div> </TD> </TR> <? $parentary = NULL ; } ?> <input type=hidden name="total" value="<? echo $strTotalNewRow; ?>"> <TR align=center> <TD colSpan=10> <? if(!$strTotalPerPage) { ?> <strong>No Referees To Game Detail Display</strong> <? } ?> </TD> </TR> </TABLE> </FORM> </TD> </TR> </TABLE> </td> </tr> </TABLE> </BODY></HTML> Link to comment https://forums.phpfreaks.com/topic/195315-select-from-database-what-am-i-doing-wrong/#findComment-1026676 Share on other sites More sharing options...
miniu Posted March 15, 2010 Author Share Posted March 15, 2010 maybe that will help too. this is the file where all the assignments comming out, but not in a table, like I want: <?php include("connect.php"); include("admin.session.php"); $LeftLinkSection = 1; $pagetitle="Assign Referee To Game"; $qstr=$_SERVER['QUERY_STRING']; if($_REQUEST["sub2"]==1) { $gid=$_REQUEST['gid']; $sel="select id from assigned_games where gid=".$gid; $res_sel=mysql_query($sel); if(mysql_num_rows($res_sel) > 0) { $msg=1; } else { $main_ref_id=$_REQUEST['mainref']; $ast_ref_id1=$_REQUEST['astref1']; $ast_ref_id2=$_REQUEST['astref2']; $main_ref_fee=$_REQUEST['mainref_fee']; $ast_ref1_fee=$_REQUEST['astref_fee']; $ast_ref2_fee=$_REQUEST['astref_fee']; $htmanager = $_REQUEST['htmanager']; $telephone = $_REQUEST['telephone']; $reffee = $_REQUEST['reffee']; $dname = $_REQUEST['dname']; $leaname = $_REQUEST['leaname']; $league_address = $_REQUEST['league_address']; $htname = $_REQUEST['htname']; $atname = $_REQUEST['atname']; $gdate = $_REQUEST['gdate']; $gtime = $_REQUEST['gtime']; $locname = $_REQUEST['lname']; $address = $_REQUEST['address']; if($main_ref_id=='') $main_ref_id=0; if($ast_ref_id1=='') $ast_ref_id1=0; if($ast_ref_id2=='') $ast_ref_id2=0; $sql_ins="insert into assigned_games set gid=$gid,main_ref_id=$main_ref_id,main_ref_fee='$main_ref_fee',ast_ref1_fee='$ast_ref1_fee',ast_ref2_fee='$ast_ref2_fee',ast_ref_id1=$ast_ref_id1,ast_ref_id2=$ast_ref_id2,assigner_id=".$_SESSION['UsErId']; $res_ins=mysql_query($sql_ins); echo mysql_error(); $sql_ass="select fname,lname,email,phone from assigners where username='".$_SESSION["UsErOfAdMiN"]."'"; $res_ass=mysql_query($sql_ass); $row_ass=mysql_fetch_object($res_ass); $fnamea=$row_ass->fname; $lnamea=$row_ass->lname; $phone=$row_ass->phone; $flname=$fnamea.' '.$lnamea; if($main_ref_id!='') { $sql_mainref="select fname,lname,email from referees where id=".$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; $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'> </td></tr> <tr><td colspan='2'>You have been assigned to the following game by Assigner <strong>".$flname."</strong> and and You have been selected as <strong>Main Referee</strong>:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><strong>League:</strong> ".stripslashes($leaname)."</td></tr> <tr><td colspan='2'><strong>Division:</strong> ".stripslashes($dname)."</td></tr> <tr><td colspan='2'><strong>Main Referee Fee:</strong> $$main_ref_fee</td></tr> <tr><td colspan='2'><strong>Home Team Name:</strong> ".stripslashes($htname)."</td></tr> <tr><td colspan='2'><strong>Away Team Name:</strong> ".stripslashes($atname)."</td></tr> <tr><td colspan='2'><strong>Home Team Manager:</strong> ".stripslashes($htmanager)."</td></tr> <tr><td colspan='2'><strong>Telephone:</strong> $telephone</td></tr> <tr><td colspan='2'><strong>Game Date:</strong> $gdate</td></tr> <tr><td colspan='2'><strong>Game Time:</strong> $gtime</td></tr> <tr><td colspan='2'><strong>Location:</strong> ".stripslashes($locname)."</td></tr> <tr><td colspan='2'><strong>Location Address:</strong> ".stripslashes($address)."</td></tr> <tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Upon completion of the game, please fill out the attached Report <a href='http://www.njsa-assignments.com/report/report.doc' target='_blank'>http://www.njsa-assignments.com/report/report.doc</a> and mail it to the $leaname WITHIN 24 HOURS at the address below:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>".stripslashes($league_address)."</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Please login at following link to accept or reject Assigned Game:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><a href='$sitepath' target='_blank'>$sitepath</a></td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Regards,</td></tr> <tr><td colspan='2'>John Zangrilli</td></tr> <tr><td colspan='2'><a href='mailto:[email protected]' target='_blank'>[email protected]</a></td></tr> <tr><td colspan='2'> </td></tr> </table> </body> </html>"; //echo $mailcontent; $to=$email; $subject="Assigning details for game: ".stripslashes($htname)." VS ".stripslashes($atname);; $from="[email protected]"; /* echo $to.'<br>'; echo $subject.'<br>'; echo $from.'<br>'; echo $mailcontent.'<br>'; exit;*/ @SendHTMLMail1($to,$subject,$mailcontent,$from); } if($ast_ref_id1!='') { $sql_mainref="select fname,lname,email from referees where id=".$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; $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'> </td></tr> <tr><td colspan='2'>You have been assigned to the following game by Assigner <strong>".$flname."</strong> and and You have been selected as <strong>Assistant Referee 1</strong>:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><strong>League:</strong> ".stripslashes($leaname)."</td></tr> <tr><td colspan='2'><strong>Division:</strong> ".stripslashes($dname)."</td></tr> <tr><td colspan='2'><strong>Assistant Referee Fee:</strong> $$ast_ref1_fee</td></tr> <tr><td colspan='2'><strong>Home Team Name:</strong> ".stripslashes($htname)."</td></tr> <tr><td colspan='2'><strong>Away Team Name:</strong> ".stripslashes($atname)."</td></tr> <tr><td colspan='2'><strong>Home Team Manager:</strong> ".stripslashes($htmanager)."</td></tr> <tr><td colspan='2'><strong>Telephone:</strong> $telephone</td></tr> <tr><td colspan='2'><strong>Game Date:</strong> $gdate</td></tr> <tr><td colspan='2'><strong>Game Time:</strong> $gtime</td></tr> <tr><td colspan='2'><strong>Location:</strong> ".stripslashes($locname)."</td></tr> <tr><td colspan='2'><strong>Location Address:</strong> ".stripslashes($address)."</td></tr> <tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Upon completion of the game, please fill out the attached Report <a href='http://www.njsa-assignments.com/report/report.doc' target='_blank'>http://www.njsa-assignments.com/report/report.doc</a> and mail it to the $leaname WITHIN 24 HOURS at the address below:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>".stripslashes($league_address)."</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Please login at following link to accept or reject Assigned Game:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><a href='$sitepath' target='_blank'>$sitepath</a></td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Regards,</td></tr> <tr><td colspan='2'>John Zangrilli</td></tr> <tr><td colspan='2'><a href='mailto:[email protected]' target='_blank'>[email protected]</a></td></tr> <tr><td colspan='2'> </td></tr> </table> </body> </html>"; $to=$email; $subject="Assigning details for game: ".stripslashes($htname)." VS ".stripslashes($atname); $from="[email protected]"; //echo $mailcontent; @SendHTMLMail1($to,$subject,$mailcontent,$from); } if($ast_ref_id2!='') { $sql_mainref="select fname,lname,email from referees where id=".$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; $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'> </td></tr> <tr><td colspan='2'>You have been assigned to the following game by Assigner <strong>".$flname."</strong> and and You have been selected as <strong>Assistant Referee 2</strong>:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><strong>League:</strong> ".stripslashes($leaname)."</td></tr> <tr><td colspan='2'><strong>Division:</strong> ".stripslashes($dname)."</td></tr> <tr><td colspan='2'><strong>Assistant Referee Fee:</strong> $$ast_ref2_fee</td></tr> <tr><td colspan='2'><strong>Home Team Name:</strong> ".stripslashes($htname)."</td></tr> <tr><td colspan='2'><strong>Away Team Name:</strong> ".stripslashes($atname)."</td></tr> <tr><td colspan='2'><strong>Home Team Manager:</strong> ".stripslashes($htmanager)."</td></tr> <tr><td colspan='2'><strong>Telephone:</strong> $telephone</td></tr> <tr><td colspan='2'><strong>Game Date:</strong> $gdate</td></tr> <tr><td colspan='2'><strong>Game Time:</strong> $gtime</td></tr> <tr><td colspan='2'><strong>Location:</strong> ".stripslashes($locname)."</td></tr> <tr><td colspan='2'><strong>Location Address:</strong> ".stripslashes($address)."</td></tr> <tr><td colspan='2'><strong>Assigner's Telephone:</strong> $phone</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Upon completion of the game, please fill out the attached Report <a href='http://www.njsa-assignments.com/report/report.doc' target='_blank'>http://www.njsa-assignments.com/report/report.doc</a> and mail it to the $leaname WITHIN 24 HOURS at the address below:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>".stripslashes($league_address)."</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Please login at following link to accept or reject Assigned Game:</td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'><a href='$sitepath' target='_blank'>$sitepath</a></td></tr> <tr><td colspan='2'> </td></tr> <tr><td colspan='2'>Regards,</td></tr> <tr><td colspan='2'>John Zangrilli</td></tr> <tr><td colspan='2'><a href='mailto:[email protected]' target='_blank'>[email protected]</a></td></tr> <tr><td colspan='2'> </td></tr> </table> </body> </html>"; //echo $mailcontent; exit; $to=$email; $subject="Assigning details for game: ".stripslashes($htname)." VS ".stripslashes($atname);; $from="[email protected]"; @SendHTMLMail1($to,$subject,$mailcontent,$from); } //exit; header("location:message.php?mid=26"); exit; } } if($_REQUEST["sub1"]==1) { $sql_gamec="select id,gid from games where 1=1"; if($_REQUEST['txtfromdate']!='') { $txtfromdate=$_REQUEST['txtfromdate']; $txtfromdate_arr=explode("-",$txtfromdate); $txtfromdate=$txtfromdate_arr[2].'-'.$txtfromdate_arr[0].'-'.$txtfromdate_arr[1]; $txttodate=$_REQUEST['txttodate']; $txttodate_arr=explode("-",$txttodate); $txttodate=$txttodate_arr[2].'-'.$txttodate_arr[0].'-'.$txttodate_arr[1]; $sql_gamec.=" and gdate >='".$txtfromdate."' and gdate<='".$txttodate."'"; } if($_REQUEST['drpdivisions']!='') { $sql_gamec.=" and div_id=".$_REQUEST['drpdivisions']; } if($_REQUEST['drpleague']!='') { $sql_gamec.=" and league_id=".$_REQUEST['drpleague']; $league=$_REQUEST['drpleague']; } $sql_gamec.=" order by id desc"; //echo $sql_gamec; exit; $res_gamec=mysql_query($sql_gamec); $totgames=mysql_num_rows($res_gamec); } if($_REQUEST["sub2"]==1) { } if($_GET["gid"]) { $game_id=$_GET['gid']; $selsql= "SELECT lea.league_name,lea.address as league_address,d.mainref_fee,d.astref_fee,g.htmanager,g.telephone,g.id, g.gid,g.gdate,dayname(g.gdate) as gday,g.gtime, d.dname, ht.tname AS htname, at.tname AS atname, l.lname,l.address FROM games g INNER JOIN divisions d ON g.div_id = d.id INNER JOIN league lea ON g.league_id = lea.id INNER JOIN teams ht ON g.home_team_id = ht.id INNER JOIN teams at ON g.away_team_id = at.id INNER JOIN locations l ON g.location_id = l.id where gid=".$_GET["gid"] ; $selres = mysql_query($selsql); echo mysql_error(); $selobj = mysql_fetch_object($selres); $mainref_fee = stripslashes($selobj->mainref_fee); $astref_fee = stripslashes($selobj->astref_fee); $league_name = stripslashes($selobj->league_name); $league_address = stripslashes($selobj->league_address); $dname = stripslashes($selobj->dname); $htname = stripslashes($selobj->htname); $atname = stripslashes($selobj->atname); $htmanager = stripslashes($selobj->htmanager); $telephone = stripslashes($selobj->telephone); $gdate = stripslashes($selobj->gdate); $gdate2 = stripslashes($selobj->gdate); $kgdate=explode('-',$gdate); $gdate=$kgdate[1].'-'.$kgdate[2].'-'.$kgdate[0]; $gtime = stripslashes($selobj->gtime); $htime=explode(':',$gtime); $ampm=explode(' ',$htime[1]); $lname = stripslashes($selobj->lname); $address = stripslashes($selobj->address); $gday=stripslashes($selobj->gday); /*$sql_ref_fee="select * from referee_fees"; $res_ref_fee=mysql_query($sql_ref_fee); $row_ref_fee=mysql_fetch_object($res_ref_fee); $mainref_fee=$row_ref_fee->mainref_fee; $astref_fee=$row_ref_fee->astref_fee; */ //echo $gday; //echo $sql_mainref="select id,fname,lname from referees where '".$gdate2."' NOT BETWEEN fromdate and todate"; } if($_GET['league_id']!='') $league=$_GET['league_id']; ?> <!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("drpgames").value=="") { alert("Please Select Game"); document.getElementById("drpgames").focus(); return false; } if(document.getElementById("astref1")!=null && document.getElementById("mainref")!=null) { if(document.getElementById("mainref").value!='' && document.getElementById("astref1").value!='') { if(document.getElementById("mainref").value==document.getElementById("astref1").value) { alert("Main Referee and Assistant Referee can not be Same"); document.getElementById("mainref").focus(); return false; } } } if(document.getElementById("astref2")!=null && document.getElementById("mainref")!=null) { if(document.getElementById("mainref").value!='' && document.getElementById("astref2").value!='') { if(document.getElementById("mainref").value==document.getElementById("astref2").value) { alert("Main Referee and Assistant Referee can not be Same"); document.getElementById("mainref").focus(); return false; } } } if(document.getElementById("astref1")!=null && document.getElementById("astref2")!=null) { if(document.getElementById("astref1").value!='' && document.getElementById("astref2").value!='') { if(document.getElementById("astref1").value==document.getElementById("astref2").value) { alert("Assistant Referee 1 and Assistant Referee 2 can not be Same"); document.getElementById("astref1").focus(); return false; } } } } function clearall() { document.getElementById('txtfromdate').value=''; document.getElementById('txttodate').value=''; document.getElementById('drpdivisions').value=''; } function IsNumericMain(strString) // check for valid numeric strings { var strValidChars = "0123456789."; var strChar; var blnResult = true; if (strString.length == 0) return false; // test strString consists of valid characters listed above for (i = 0; i < strString.length && blnResult == true; i++) { strChar = strString.charAt(i); if (strValidChars.indexOf(strChar) == -1) { alert("Please Enter Digits"); document.getElementById('main_ref_fee').value=''; document.getElementById('main_ref_fee').focus(); blnResult = false; } } return blnResult; } function IsNumericAstRef1(strString) { var strValidChars = "0123456789."; var strChar; var blnResult = true; if (strString.length == 0) return false; // test strString consists of valid characters listed above for (i = 0; i < strString.length && blnResult == true; i++) { strChar = strString.charAt(i); if (strValidChars.indexOf(strChar) == -1) { alert("Please Enter Digits"); document.getElementById('ast_ref1_fee').value=''; document.getElementById('ast_ref1_fee').focus(); blnResult = false; } } return blnResult; } function IsNumericAstRef2(strString) { var strValidChars = "0123456789."; var strChar; var blnResult = true; if (strString.length == 0) return false; // test strString consists of valid characters listed above for (i = 0; i < strString.length && blnResult == true; i++) { strChar = strString.charAt(i); if (strValidChars.indexOf(strChar) == -1) { alert("Please Enter Digits"); document.getElementById('ast_ref2_fee').value=''; document.getElementById('ast_ref2_fee').focus(); blnResult = false; } } return blnResult; } function select_game(val,sub1,txtfrom,txtto,drp_division) { window.location.href='assign_referee_to_game.php?gid=' + val + '&sub1=' + sub1 + '&txtfromdate=' + txtfrom + '&txttodate=' + txtto + '&drpdivisions=' + drp_division; } function show_divisions(val) { window.location.href='assign_referee_to_game.php?league_id=' + val; } function show_getgames() { if(document.getElementById('txtfromdate').value!='' && document.getElementById('txttodate').value=='') { alert('Please Select To Date'); document.getElementById('txttodate').focus(); return false; } if(document.getElementById('txttodate').value!='' && document.getElementById('txtfromdate').value=='') { alert('Please Select From Date'); document.getElementById('txtfromdate').focus(); return false; } if(document.getElementById('txttodate').value < document.getElementById('txtfromdate').value) { alert('To Date can not be less then From Date'); document.getElementById('txttodate').focus(); return false; } document.getElementById('sub1').value=1; document.frmgetgames.submit(); } </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> <tr><td> </td></tr> <tr><td> </td></tr> <tr><td align="center"><form name="frmgetgames" id="frmgetgames" method="post"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td width="100%" colspan="2" align="left"> From Date: <input type="text" name="txtfromdate" readonly="true" id="txtfromdate" size="15" value="<?=stripslashes($_REQUEST['txtfromdate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txtfromdate'));"> Select Date</a> To Date: <input type="text" name="txttodate" readonly="true" id="txttodate" size="15" value="<?=stripslashes($_REQUEST['txttodate']);?>"> <a href="#" onClick="getCalendar(document.getElementById('txttodate'));"> Select Date</a> <br><br> <select name="drpleague" id="drpleague" style="width:150px" onChange="show_divisions(this.value)"> <option value="">--Select--</option> <? $sql_league="select * from league"; $res_league=mysql_query($sql_league); while($row_league=mysql_fetch_object($res_league)) { ?> <option value="<?=$row_league->id?>" <? if($row_league->id==$league) echo "selected='selected'"; ?>><?=stripslashes($row_league->league_name)?></option> <? } ?> </select> <? if($league!='') { ?> <select id="drpdivisions" name="drpdivisions"> <option value="">--Select Division--</option> <? $sql_division="select * from divisions where league_id=".$league." order by dname"; $res_division=mysql_query($sql_division); while($row_division=mysql_fetch_object($res_division)) { ?> <option value="<?=$row_division->id?>" <? if($_REQUEST['drpdivisions']==$row_division->id) echo "selected='selected'"; ?>><?=stripslashes($row_division->dname);?></option> <? } ?> </select><? } ?><br><br> <input type="button" value="Get Games" onClick="show_getgames();"><input type="hidden" id="sub1" name="sub1" value="0"> <input type="button" value="Clear" onClick="clearall();"> </td> </tr> </table></form> </td></tr> <tr><td> </td></tr> <tr><td> </td></tr> <? if($msg==1) { ?> <tr><td class="error" height="30"><font color="red"><strong>Game is already assigned to Referees!</strong></font></td></tr> <? } ?> <TR> <TD> <? if(($_REQUEST['sub1']==1 && $totgames > 0) || ($_GET['gid']!='' && $totgames > 0)) { ?> <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?> </td> </tr> <tr> <td width="37%" align="right"><font color="red">*</font> Select Game:</td> <td width="63%"><font color="<?=$col?>"> <select name="drpgames" id="drpgames" style="width:300px" onChange="select_game(this.value,'<?=$_REQUEST['sub1']?>','<?=$_REQUEST['txtfromdate']?>','<?=$_REQUEST['txttodate']?>','<?=$_REQUEST['drpdivisions']?>');"> <option value="">--Select Game--</option> <? $sql_game="SELECT lea.league_name,lea.address as league_address,d.mainref_fee,d.astref_fee,g.htmanager,g.telephone,g.id,g.gid,g.gdate,dayname(g.gdate) as gday,g.gtime, d.dname, ht.tname AS htname, at.tname AS atname, l.lname,l.address FROM games g INNER JOIN divisions d ON g.div_id = d.id INNER JOIN league lea ON g.league_id = lea.id INNER JOIN teams ht ON g.home_team_id = ht.id INNER JOIN teams at ON g.away_team_id = at.id INNER JOIN locations l ON g.location_id = l.id where 1=1"; if($txtfromdate!='') { $sql_game.=" and g.gdate >='".$txtfromdate."' and g.gdate<='".$txttodate."'"; } if($_REQUEST['drpdivisions']!='') { $sql_game.=" and g.div_id=".$_REQUEST['drpdivisions']; } if($_REQUEST['drpleague']!='') { $sql_game.=" and lea.id=".$_REQUEST['drpleague']; $league=$_REQUEST['drpleague']; } $res_game=mysql_query($sql_game); while($row_game=mysql_fetch_object($res_game)) { ?> <option value="<?=$row_game->gid;?>" <? if($game_id==$row_game->gid) echo "selected='selected'"; ?>><? echo $row_game->league_name.'=>'.$row_game->dname.'=>'.$row_game->htname.' VS '.$row_game->atname;?></option> <? } ?> </select> </font></td> </tr> <? if($_GET['gid']!='') { ?> <tr> <td width="37%" align="right"><font color="red"></font> League:</td> <td width="63%"><font color="<?=$col?>"><?=$league_name;?><input type="hidden" id="leaname" name="leaname" value="<?=$league_name?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> League Address:</td> <td width="63%"><font color="<?=$col?>"><?=$league_address;?><input type="hidden" id="league_address" name="league_address" value="<?=$league_address?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Division:</td> <td width="63%"><font color="<?=$col?>"><?=$dname;?><input type="hidden" id="dname" name="dname" value="<?=$dname?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Home Team:</td> <td width="63%"><font color="<?=$col?>"><?=$htname;?><input type="hidden" id="htname" name="htname" value="<?=$htname?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Away Team:</td> <td width="63%"><font color="<?=$col?>"><?=$atname;?><input type="hidden" id="atname" name="atname" value="<?=$atname?>"> </font></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" id="htmanager" name="htmanager" 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" id="telephone" name="telephone" value="<?=$telephone?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Date of Game:</td> <td width="63%"><font color="<?=$col?>"><?=$gdate;?><input type="hidden" id="gdate" name="gdate" value="<?=$gdate?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Date Time:</td> <td width="63%"><font color="<?=$col?>"><?=$gtime;?><input type="hidden" id="gtime" name="gtime" value="<?=$gtime?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Location:</td> <td width="63%"><font color="<?=$col?>"><?=$lname;?><input type="hidden" id="lname" name="lname" value="<?=$lname?>"> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Location Address:</td> <td width="63%"><font color="<?=$col?>"><?=$address;?><input type="hidden" id="address" name="address" value="<?=$address?>"> </font></td> </tr> <? if($mainref_fee!='') { ?> <tr> <td width="37%" align="right"><font color="red"></font> Main Referee:</td> <td width="63%"> <font color="<?=$col?>"><select id="mainref" name="mainref" style="width:180px"> <option value="">--Select--</option> <? $sql_mainref="select id,fname,lname from referees where '".$gdate2."' NOT BETWEEN fromdate and todate"; $res_mainref=mysql_query($sql_mainref); while($row_mainref=mysql_fetch_object($res_mainref)) { ?> <option value="<?=$row_mainref->id?>"><?=$row_mainref->fname.' '.$row_mainref->lname?></option> <? } ?> </select> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Main Referee's Fee:</td> <td width="63%"><font color="<?=$col?>">$<?=$mainref_fee?><input type="hidden" name="mainref_fee" value="<?=$mainref_fee?>"> </font></td> </tr> <? } else { ?> <input type="hidden" name="old_main_ref_id" id="old_main_ref_id" value="<?=$main_ref_id?>"> <input type="hidden" name="mainref_fee" value="<?=$mainref_fee?>"> <? } ?> <? if($astref_fee!='') { ?> <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"; $res_astref1=mysql_query($sql_astref1); while($row_astref1=mysql_fetch_object($res_astref1)) { ?> <option value="<?=$row_astref1->id?>"><?=$row_astref1->fname.' '.$row_astref1->lname?></option> <? } ?> </select> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Assistant Referee 1's Fee:</td> <td width="63%"><font color="<?=$col?>">$<?=$astref_fee?><input type="hidden" name="astref_fee" value="<?=$astref_fee?>"> </font></td> </tr> <? } else { ?> <input type="hidden" name="old_ast_ref_id1" id="old_ast_ref_id1" value="<?=$ast_ref_id1?>"> <input type="hidden" name="astref_fee" value="<?=$astref_fee?>"> <? } ?> <? if($astref_fee!='') { ?> <tr> <td width="37%" align="right"><font color="red"></font> Assistant Referee 2:</td> <td width="63%"><font color="<?=$col?>"><select id="astref2" name="astref2" style="width:180px"> <option value="">--Select--</option> <? $sql_astref2="select id,fname,lname from referees where '".$gdate2."' NOT BETWEEN fromdate and todate"; $res_astref2=mysql_query($sql_astref2); while($row_astref2=mysql_fetch_object($res_astref2)) { ?> <option value="<?=$row_astref2->id?>"><?=$row_astref2->fname.' '.$row_astref2->lname?></option> <? } ?> </select> </font></td> </tr> <tr> <td width="37%" align="right"><font color="red"></font> Assistant Referee 2's Fee:</td> <td width="63%"><font color="<?=$col?>">$<?=$astref_fee?> </font></td> </tr> <? } else { ?> <input type="hidden" name="old_ast_ref_id2" id="old_ast_ref_id2" value="<?=$ast_ref_id2?>"> <input type="hidden" name="astref_fee" value="<?=$astref_fee?>"> <? } ?> <? } ?> <tr> <td> <input type="hidden" value="<?=$_GET["id"]; ?>" name="id"></td> <td><input name="Submit" type="submit" class="buttonclass" value="Submit" onClick="return kyb_check();" /></td> <input type="hidden" name="sub2" value="1"> </tr> </table></form><? } else { ?><? if($_POST['sub1']!='') { ?><table cellpadding="0" cellspacing="0" border="0" align="center"> <tr><td class="error" height="30"><font color="red"><strong>No Games will be played between these Dates!</strong></font></td></tr> </table><? } ?> <? } ?> </TD> </TR> </TABLE> </td> </tr> </TABLE> </BODY></HTML> Link to comment https://forums.phpfreaks.com/topic/195315-select-from-database-what-am-i-doing-wrong/#findComment-1026689 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.