miniu Posted March 16, 2010 Share Posted March 16, 2010 I have here a table as you can see with games. I have also a field called Location Address. In the sql database it is as: table: locations and the fields name are: lname and address but there are not showing? why? What am I doing wrong? What should I change? <?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><br/> <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%'"; $lname = stripslashes($selobj->lname); } 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) { $sql_gamec="select id,gid from games where 1=1"; } 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="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">Location Address</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="20%" 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">Referees</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->address); ?></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); ?><? 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>"; ?><br><? echo stripslashes($row->r2fname).' '.stripslashes($row->r2lname); ?><? 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>"; } ?><br><? echo stripslashes($row->r3fname).' '.stripslashes($row->r3lname); ?><? 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> Quote Link to comment Share on other sites More sharing options...
MidOhioIT Posted March 16, 2010 Share Posted March 16, 2010 in your fetch for $result I dont see where your taking the row and assigning it to any variable. I usually do something like this: while($row = mysql_fetch_object($result)) { $id = $row["seq_id"]; } Then just use $id as a normal variable. if your doing this I didnt see it... also food for thought... there are some instances your using tags <?php ?> and also <? ?> you should just stick to the new style and only use one style, makes it easy to read and if im not mistaken the new version of php likes <?php ?> anyways.. another thing to make sure of is run your query on the database to make sure you have actual results. you can also use the die function and it would let you know if you have a syntax error Quote Link to comment Share on other sites More sharing options...
AdRock Posted March 16, 2010 Share Posted March 16, 2010 try changing $sql="delete from assigned_games where id=".$_GET['did']; to $sql="delete from assigned_games where id='".$_GET['did']."'"; Quote Link to comment Share on other sites More sharing options...
MidOhioIT Posted March 16, 2010 Share Posted March 16, 2010 adrock, I am not sure he is talking about the delete statement, there is a select statement in there too. Miniu, can you be more clear on what sql statement your having problems with? Quote Link to comment Share on other sites More sharing options...
miniu Posted March 17, 2010 Author Share Posted March 17, 2010 Yes. It doesn't shows me the league address Quote Link to comment Share on other sites More sharing options...
MidOhioIT Posted March 17, 2010 Share Posted March 17, 2010 You still have not specified, what is the name of the cursor your tring to fetch from? Quote Link to comment Share on other sites More sharing options...
miniu Posted March 17, 2010 Author Share Posted March 17, 2010 You still have not specified, what is the name of the cursor your tring to fetch from? I don't understand Quote Link to comment Share on other sites More sharing options...
MidOhioIT Posted March 18, 2010 Share Posted March 18, 2010 ok, assuming your talking about a select statement since your saying "It doesn't shows me the league address". what is your select statement? where is it in the code so I can look at it and understand what exactly is not working for you? 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.