StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCode logic not computing correct data
primarykey
Id
5212729
data
AcceptedAnswerId
5212852
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-03-06T19:08:23.550
FavoriteCount
0
LastActivityDate
2011-11-17T00:11:09.267
LastEditDate
2011-11-17T00:11:09.267
LastEditorUserId
690430
OwnerUserId
647216
ParentId
0
PostTypeId
1
Score
1
ViewCount
246
LastEditorDisplayName
text
Body
<p>I'm desperately hoping someone can assist me with this error. Admittedly, I'm a novice and I've tried for literally 60+ hours to fix this but I just can't get there. </p> <p>Right, here goes. </p> <p>I have a football league table of 20 teams. It works, it's great, happy days. However, I needed to reduce it to 12 teams. A problem because I didn't create the website, someone else did a while back. </p> <p>So I've needed to amend a table with 20, to 12. That's all. </p> <p>Daunted, I rolled up my sleeves scoured the code and located this bit; </p> <pre><code><?php $query = $SITE -> Query ( 'SELECT a.*, b.name, b.colour, b.txtcolour, (sum((a.wins*3) + (a.draws*1) - a.pts)) as points, (sum(a.wins + a.losses + a.draws)) as pld, (sum(a.glsfor - a.glsaga)) as gd FROM got_standings a inner join got_clubs b on (a.cid = b.id) WHERE a.season = "'.$url[2].'" GROUP BY a.cid ORDER BY points DESC, gd DESC, glsfor DESC' ); if ($SITE -> Count ($query) == 0) { $loop = 0; while($loop <= 19) { ++$loop; ?> </code></pre> <p>After some trial and error in those 60 hours I've been trying to resolve, I changed; </p> <p><strong>while($loop <= 19)</strong> </p> <p>to; </p> <p><strong>while($loop <= 11)</strong> </p> <p>And low and behold, the system now prompted me to enter 12 teams into a league table, as oppose to 20. Superb. Or so I thought... </p> <p>When I first enter the data into the table and 'submit', it works - as it did perfectly when 20 teams where listed before the above change. However, when I 'update'/make any continual changes to the league table, it also calculates the previous </p> <p>So for 'Port Talbot Town' I enter "1 Win", "1 Draw", "1 Loss", "5 Goals Scored" "5 Goals Conceded" And it works. It calculates 3 games played and 4 points (3 for a win, 1 for a draw, 0 for a loss)<a href="http://i1116.photobucket.com/albums/k562/nilsatis88/4.jpg" rel="nofollow">as shown here</a>. </p> <p>BUT, when I then enter other information, so entering the same information for 'Aberystwyth Town'and 'update', the information for the previous data (Port Talbot Town) is calculated again?<a href="http://i1116.photobucket.com/albums/k562/nilsatis88/5.jpg" rel="nofollow">as shown here</a>. </p> <p>I'm at complete loss. I'd be incredibly grateful and appreciative for any assistance. </p> <p>The entire code is pasted at the bottom of this. </p> <p>Please guys! Help an idiot out! 8) </p> <pre><code><?php } } else if ($url[3] == 'league') { if ($url[4] == 'standings') { ?> <ul class="buttonbar"> <li class="button"><a href="<?=$CONF['site']; ?>sitecontrol/fixtures/<?=$url[2]; ?>/add/league">Add Fixture</a></li> <li class="button"><a href="<?=$CONF['site']; ?>sitecontrol/fixtures/<?=$url[2]; ?>/league/standings">Standings</a></li> </ul> <form action="<?=$CONF['site']; ?>mcms/applications/fixtures/submit.php?do=fixtures&amp;action=standings&amp;season=<?=$url [2]; ?>&amp;comp=<?=$url[3]; ?>" method="post" name="standings"> <div class="table"> <div class="th">Welsh Premier League Standings</div> <ul class="tr shadow"> <li class="td-squadno">Pos.</li> <li class="td4" style="width: 170px;">Team</li> <li class="td4">PLD</li> <li class="td4">W</li> <li class="td4">D</li> <li class="td4">L</li> <li class="td4">+</li> <li class="td4">-</li> <li class="td4">PTS</li> </ul> <?php $query = $SITE -> Query ( 'SELECT a.*, b.name, b.colour, b.txtcolour, (sum((a.wins*3) + (a.draws*1) - a.pts)) as points, (sum(a.wins + a.losses + a.draws)) as pld, (sum(a.glsfor - a.glsaga)) as gd FROM got_standings a inner join got_clubs b on (a.cid = b.id) WHERE a.season = "'.$url[2].'" GROUP BY a.cid ORDER BY points DESC, gd DESC, glsfor DESC' ); if ($SITE -> Count ($query) == 0) { $loop = 0; while($loop <= 11) { ++$loop; ?> <ul class="tr" id="team_<?=$loop; ?>"> <li class="td-squadno"><?=$loop; ?></li> <li class="td2" style="width: 170px;"> <?php echo ( ' <select name="cid[]"> ' ); $sql = $SITE -> Query ( 'SELECT id, name FROM got_clubs WHERE country = "Wales" ORDER BY name ASC' ); while($club = $SITE -> FetchArray($sql)) { echo ( '<option value="'.$club['id'].'"' ); if ($club['id'] == '1') echo ( ' SELECTED' ); echo ( '>'.$club['name'].'</option>' ); } echo ( ' </select> ' ); ?> </li> <li class="td4"></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=wins[]]').val(parseInt($('ul#team_<? =$loop; ?> li.td4 input[name=wins[]]').val())+1); return false;">+</a> <input type="text" name="wins[]" value="0" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=draws[]]').val(parseInt($('ul#team_<? =$loop; ?> li.td4 input[name=draws[]]').val())+1); return false;">+</a> <input type="text" name="draws[]" value="0" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=losses[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=losses[]]').val())+1); return false;">+</a> <input type="text" name="losses[]" value="0" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=glsfor[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=glsfor[]]').val())+1); return false;">+</a> <input type="text" name="glsfor[]" value="0" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=glsaga[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=glsaga[]]').val())+1); return false;">+</a> <input type="text" name="glsaga[]" value="0" /></li> <li class="td4">- <input type="text" name="pts[]" /></li> </ul> <?php } } else { $loop = 0; while($row = $SITE -> FetchArray($query)) { ++$loop; ?> <ul class="tr" id="team_<?=$loop; ?>"> <li class="td-squadno"><?=$loop; ?></li> <li class="td-club" style="width: 160px; margin-left: 10px; background-color: #<?=$row['colour']; ?>; color: #<? =$row['txtcolour']; ?>;"><?=$row['name']; ?><input type="hidden" name="cid[]" value="<?=$row['cid']; ?>" /></li> <li class="td4"><?=$row['pld']; ?></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=wins[]]').val(parseInt($('ul#team_<? =$loop; ?> li.td4 input[name=wins[]]').val())+1); return false;">+</a> <input type="text" name="wins[]" value="<?=$row ['wins']; ?>" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=draws[]]').val(parseInt($('ul#team_<? =$loop; ?> li.td4 input[name=draws[]]').val())+1); return false;">+</a> <input type="text" name="draws[]" value="<?=$row ['draws']; ?>" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=losses[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=losses[]]').val())+1); return false;">+</a> <input type="text" name="losses[]" value="<?=$row['losses']; ?>" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=glsfor[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=glsfor[]]').val())+1); return false;">+</a> <input type="text" name="glsfor[]" value="<?=$row['glsfor']; ?>" /></li> <li class="td4"><a href="#" onclick="$('ul#team_<?=$loop; ?> li.td4 input[name=glsaga[]]').val(parseInt ($('ul#team_<?=$loop; ?> li.td4 input[name=glsaga[]]').val())+1); return false;">+</a> <input type="text" name="glsaga[]" value="<?=$row['glsaga']; ?>" /></li> <li class="td4"><?=$row['points']; ?> (- <input type="text" name="pts[]" value="<?=$row['pts']; ?>" />)</li> </ul> <?php } } ?> <div class="tf"><input type="submit" value="Update Standings" /> or <a href="<?=$CONF['site']; ?>sitecontrol/fixtures/<? =$url[2].'/'.$url[3]; ?>">Cancel</a></div> </div> </form> <p>Do not use the points column for anything other than points deductions. If a points deduction is carried out by the Premier League, use the input box to enter how many points have been taken away, e.g. Portsmouth in 2009/10 would have &quot;9&quot; in their points input box.</p> <p>Matches played and points columns will update automatically. The position of each team in the league table will also be automatically updated.</p> <?php } else { ?> <ul class="buttonbar"> <li class="button"><a href="<?=$CONF['site']; ?>sitecontrol/fixtures/<?=$url[2]; ?>/add/league">Add Fixture</a></li> <li class="button"><a href="<?=$CONF['site']; ?>sitecontrol/fixtures/<?=$url[2]; ?>/league/standings">Standings</a></li> </ul> <div class="table"> <div class="th">Premier League Fixtures</div> <?php $query = $SITE -> Query ( ' SELECT a.id, a.rid, home, away, homescore, awayscore, date, b.name as hometeam, c.name as awayteam FROM got_fixtures a inner join got_clubs b on (a.home = b.id) inner join got_clubs c on (a.away = c.id) WHERE a.cid="1" AND a.season = "'.$url[2].'" AND (a.home = "1" OR a.away = "1") ORDER BY date ASC' ); while($row = $SITE -> FetchArray($query)) { ?> <ul class="tr"> <li class="td-squadno"><?=$row['rid']; ?></li> <li class="td-home"><?=$row['hometeam']; ?></li> <li class="td-score"><?=$row['homescore']; ?> - <?=$row['awayscore']; ?></li> <li class="td-away"><?=$row['awayteam']; ?></li> <li class="td-kickoff"><?=date('D. jS F y, H:i', $row['date']); ?></li> <li class="td-end"><a href="<?=$CONF['site']?>sitecontrol/fixtures/<?=$url[2]; ?>/edit/<?=$url[3]; ?>/<?=$row['id']; ?>">Edit</a> or <a href="<?=$CONF['site']; ?>mcms/applications/fixtures/submit.php?do=fixtures&amp;action=delete&amp;id=<? =$row['id']; ?>&amp;comp=<?=$url[3]; ?>&amp;season=<?=$url[2]; ?>">Remove</a></li> </ul> <?php } ?> <div class="tf"></div> </div> </code></pre>
Tags
<php><mysql>
Title
Code logic not computing correct data
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USksindi
UserOwnerUserId
1. USDan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POCode logic not computing correct data
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
2. VO
  singulars
  PostPostId
  POCode logic not computing correct data
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COconsider changing title to a relevant one. Let people decide who you are based on your question. Do not self advertise.
  singulars
  PostPostId
  POCode logic not computing correct data
  UserUserId
  USNishant

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.