kemper
Members-
Posts
230 -
Joined
-
Last visited
Never
Everything posted by kemper
-
My league does not keep scores and standings for younger ages. How can alter my code to not display any recorded scores if confid < 11??? <?php print "<table width='100%' class='tbl-border'>\n"; print "<tr><th class='tbl2'>Date</th><th class='tbl2'>Home Team</th><th class='tbl2'>Score</th><th class='tbl2'>Visiting Team</th><th class='tbl2'>Score</th>"; if ($show_fields) print "<th class='tbl2'>Field</th>\n"; $queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.game_date, sportsdb_wins.game_time, sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.winortie, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie != 3"; // Sort by team if specified if (isset($_POST['teamtosort']) && $_POST['teamtosort'] != 'all') { $teamtosort = intval($_POST['teamtosort']); $queryscores .= " AND (sportsdb_wins.winner = $teamtosort OR sportsdb_wins.loser = $teamtosort)"; } $queryscores .= " ORDER BY wintime ASC"; $resultscores=mysql_query($queryscores); $numscores=mysql_numrows($resultscores); while ($scores = mysql_fetch_array($resultscores, MYSQL_ASSOC)) { $windateheader=$scores['windate']; $windateformatted=date("l, F j",$windateheader); $time = date('g:i a',$scores['wintime']); $time = ($time == "12:00 am")? "<font color='#ff0000'>TBA</font>" : $time; print "<tr><td class='tbl1'>$windateformatted</td><td class='tbl1'>{$scores['winningteam']}</td>"; print "<td class='tbl1' align='center'><b>{$scores['rf']}</b></td> <td class='tbl1'>{$scores['losingteam']}</td>"; print "<td class='tbl1' align='center'><b>{$scores['ra']}</b></td>"; if ($show_fields) print "<td class='tbl1'>{$scores['field']}</td>"; if ($scores['winortie'] == 2 || $scores['winortie'] == 5) print " (ff)"; print "</td></tr>\n"; } echo "</table>\n"; ?> I want the table to display all, but (for confid < 11) have open cells for $scores['rf'] and $scores['ra'] fields
-
Getting back to this topic, uniflare's code: $resultconf = mysql_query("SELECT confname FROM sportsdb_conferences WHERE confid = $confid AND confid < 12 LIMIT 1"); took everything off the page. My original script displays Standings table, followed by schedules and results. I want the schedules/results table to remain for confids <12. The code should only affect the displaying of the Standings table as we do not keep standings for those ages (confid). Maybe my issue is where I updated the query. I thought it should be updated in the query above the standings table details. I thought that was the query to update. I must be wrong. Assistance is greatly appreciated.
-
Thanks! That did the trick. I am unsure why the code was written that way for the time. It seems to tedious. TBA was what I wanted listed for 1:03am.
-
I cannot seem to get it to work as I am declaring: $wintime=$scores['wintime']; $hour=date('g',$wintime); $minute=date('i',$wintime); $ampm=date('a',$wintime); and echoing > " . $hour . ":" . $minute . $ampm . "
-
This may seem like an odd request, but I deal with some odd people that will believe 1:03 am is supposed to be 1:00 pm-ish. I need to avoid those issues, but the other website that I coordinate with utilized 1:03 am as a TBA time designation. I need to change my script to display "TBA" for that time designation. Assistance is greatly appreciated. <?php print "<table width='100%' class='tbl-border'>\n"; print "<tr> <th class='tbl2' colspan='6' align='left'> <font color='#ff0000'><b>Any games noted as POSTPONED have the league's permission for reschedule.</b> Coaches/managers should contact the opposing team manager and/or coach. With a coordinated effort, arrange for a suitable make-up date and time. Home Team coach/manager should contact their Club Field Scheduler to verify when fields are available.</font></th></tr><tr><th class='tbl2'>Status</th><th class='tbl2'>Date</th><th class='tbl2'>Time</th><th class='tbl2'>Home Team</th><th class='tbl2'>Visiting Team</th>"; if ($show_fields) print "<th class='tbl2'>Field</th>"; $queryscores = "SELECT sportsdb_wins.winid, sportsdb_wins.status, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.field_no, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie = 3"; // Sort by team if specified if (isset($_POST['teamtosort']) && $_POST['teamtosort'] != 'all') { $teamtosort = intval($_POST['teamtosort']); $queryscores .= " AND (sportsdb_wins.winner = $teamtosort OR sportsdb_wins.loser = $teamtosort)"; } $queryscores .= " ORDER BY windate ASC, wintime ASC"; $resultscores = mysql_query($queryscores); $numscores = mysql_numrows($resultscores); while ($scores = mysql_fetch_array($resultscores, MYSQL_ASSOC)) { $windateheader=$scores['windate']; $windateformatted=date("F d, Y",$windateheader); $wintime=$scores['wintime']; $hour=date('g',$wintime); $minute=date('i',$wintime); $ampm=date('a',$wintime); print "<tr><td class='tbl1'>{$scores['status']}</td><td class='tbl1'>$windateformatted</td><td class='tbl1'>" . $hour . ":" . $minute . $ampm . "</td><td class='tbl1'>{$scores['winningteam']}</td><td class='tbl1'>{$scores['losingteam']}</td>"; if ($show_fields) print "<td class='tbl1'>{$scores['field']} {$scores['field_no']}</td>"; } echo "</table>\n"; ?> The Time table field is setup as: `wintime` int(11) NOT NULL default '0',
-
I am not getting error, per say. With your replaced query, the confids > 12 show. confid 1 through 11 do not show anything. No schedules, no data. Alll I get for those is "No such division" For confid < 12, i do not want to show: <table width='100%' class='tbl-border'> <tr><td class='tbl2' width='55%'><?php if ($standings_sort != 1) print "<a href=\"index.php?conf=$confid&sort=1\">"; ?><b>Team Name</b><?php if ($standings_sort != 1) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 6) print "<a href=\"index.php?conf=$confid&sort=6\">"; ?><strong>GP</strong><?php if ($standings_sort != 2) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 2) print "<a href=\"index.php?conf=$confid&sort=2\">"; ?><b>W</b><?php if ($standings_sort != 2) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 3) print "<a href=\"index.php?conf=$confid&sort=3\">"; ?><b>L</b><?php if ($standings_sort != 3) print "</a>"; ?></td> <?php if ($show_ties) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 4) print "<a href=\"index.php?conf=$confid&sort=4\">"; ?><b>T</b><?php if ($standings_sort != 4) print "</a>"; ?></td> <?php } ?> <?php if ($forfeit) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 5) print "<a href=\"index.php?conf=$confid&sort=5\">"; ?><b>Forfeits</b><?php if ($standings_sort != 5) print "</a>"; ?></td> <?php } ?> <?php if ($show_rfra) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 7) print "<a href=\"index.php?conf=$confid&sort=7\">"; ?><b>GF</b><?php if ($standings_sort != 7) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != print "<a href=\"index.php?conf=$confid&sort=8\">"; ?><b>GA</b><?php if ($standings_sort != print "</a>"; ?></td> <?php } ?> <?php if ($show_gb) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 9) print "<a href=\"index.php?conf=$confid&sort=9\">"; ?><b>GB</b><?php if ($standings_sort != 9) print "</a>"; ?></td> <?php } ?> <td class='tbl2' align='center' width='10%'><?php if ($standings_sort != 0) print "<a href=\"index.php?conf=$confid&sort=0\">"; ?><b>PCT</b><?php if ($standings_sort != 0) print "</a>"; ?></td> <?php if ($show_points) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 10) print "<a href=\"index.php?conf=$confid&sort=10\">"; ?><b>Pts</b><?php if ($standings_sort != 10) print "</a>"; ?></td> <?php } ?> </tr> <?php $query = "SELECT COUNT(*) FROM sportsdb_teams WHERE teamdiv = {$divs['divid']}"; $result = mysql_query($query); $result_exist = mysql_result($result,0); if ($result_exist) { $query = "SELECT teamid, teamname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra, (teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed, (teamwins / (teamwins + teamlosses + teamforfeits)) AS winningpct, (teamwins - teamlosses - teamforfeits) AS leadervalue, (teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points FROM sportsdb_teams WHERE teamdiv = {$divs['divid']} ORDER BY leadervalue DESC, teamties DESC LIMIT 1"; $result = mysql_query($query) or die ("Error in query: $query"); $results = mysql_fetch_array($result, MYSQL_ASSOC); $winningpct=number_format($results['winningpct'], 3); } // Show the leader at the top for default sorting (games behind) if ($standings_sort == 9) { print "<tr><td class='tbl1' width='55%'><em>{$results['teamname']}</em></td><td class='tbl1' align='center' width='5%'>{$results['gamesplayed']}</td><td class='tbl1' align='center' width='5%'>{$results['teamwins']}</td><td class='tbl1' align='center' width='5%'>{$results['teamlosses']}</td>"; if ($show_ties) print "<td class='tbl1' align='center' width='5%'>{$results['teamties']}</td>"; if ($forfeit) print "<td class='tbl1' align='center' width='5%'>{$results['teamforfeits']}</td>"; if ($show_rfra) print "<td align='center' class='tbl1' width='5%'>{$results['teamrf']}</td><td align='center' class='tbl1' width='5%'>{$results['teamra']}</td>"; if ($show_gb) print "<td class='tbl1' align='center' width='5%'>---</td>"; print "<td class='tbl1' align='center' width='10%'>$winningpct</td>"; if ($show_points) print "<td class='tbl1' align='center' width='5%'>{$results['points']}</td>"; print "</tr>\n"; } if ($result_exist) { $query="SELECT teamid, teamname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra, (teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed, (teamwins / (teamwins + teamlosses + teamforfeits)) AS winningpct, ((({$results['leadervalue']}) - (teamwins - teamlosses - teamforfeits)) / 2) AS gamesbehind, (teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points FROM sportsdb_teams WHERE teamdiv = {$divs['divid']}"; if ($standings_sort == 9) { $query .= " AND teamid != {$results['teamid']}"; } $query .= " AND active = 1" . $division_sort . " ORDER BY $sort_order"; $result=mysql_query($query); $num=mysql_numrows($result); while ($results = mysql_fetch_array($result, MYSQL_ASSOC)) { $winningpct=number_format($results['winningpct'], 3); $gamesbehind = number_format($results['gamesbehind'],1); if ($gamesbehind == "0.0") $gamesbehind = "---"; print "<tr><td class='tbl1'><em>{$results['teamname']}</em></td><td class='tbl1' align='center'>{$results['gamesplayed']}</td><td class='tbl1' align='center'>{$results['teamwins']}</td><td class='tbl1' align='center'>{$results['teamlosses']}</td>"; if ($show_ties) print "<td class='tbl1' align='center'>{$results['teamties']}</td>"; if ($forfeit) print "<td class='tbl1' align='center'>{$results['teamforfeits']}</td>"; if ($show_rfra) print "<td class='tbl1' align='center'>{$results['teamrf']}</td><td class='tbl1' align='center'>{$results['teamra']}</td>"; if ($show_gb) print "<td class='tbl1' align='center'>$gamesbehind</td>"; print "<td class='tbl1' align='center'>$winningpct</td>"; if ($show_points) print "<td class='tbl1' align='center'>{$results['points']}</td>"; print "</tr>\n"; } } print "</table> that is starting at line 56
-
That actually took conferences 12 to 40 and displayed "No Such Division". It did not even display the schedules.
-
<?php $confid = intval($_GET['conf']); mysql_connect($sportsdb_host,$sportsdb_user,$sportsdb_pass); @mysql_select_db($sportsdb_db) or die( "Unable to select database"); // Allow sorting to occur $standings_sort = intval($_GET['sort']); switch ($standings_sort) { case 1: $sort_order = "teamname ASC"; break; case 2: $sort_order = "teamwins DESC, teamties DESC, teamlosses ASC"; break; case 3: $sort_order = "teamlosses DESC, teamwins ASC, teamties ASC"; break; case 4: $sort_order = "teamties DESC, teamwins DESC, teamlosses ASC"; break; case 5: $sort_order = "teamforfeits DESC, teamwins ASC, teamties ASC"; break; case 6: $sort_order = "gamesplayed DESC, teamwins DESC, teamties DESC, teamlosses ASC"; break; case 7: $sort_order = "teamrf DESC, teamwins ASC, teamties DESC, teamlosses ASC"; break; case 8: $sort_order = "teamra DESC, teamwins DESC, teamties ASC, teamlosses DESC"; break; case 9: $sort_order = "gamesbehind ASC, teamties DESC, teamwins DESC, teamlosses ASC"; break; case 10: $sort_order = "points DESC, teamwins DESC, winningpct DESC"; break; default: $standings_sort = 10; $sort_order = "points DESC, teamra ASC, teamrf DESC, teamname ASC"; } $division_sort = ""; if ($confid > 0) { // print the conference name $resultconf = mysql_query("SELECT confname FROM sportsdb_conferences WHERE confid = $confid LIMIT 1"); $numconf = mysql_num_rows($resultconf); if ($numconf == 0) die ("No such division"); opentable ("Spring 2008 Season Details"); print "<p><a href=\"index.php\">Back to division list</a></p>\n<hr />\n"; // Get the divisions $resultconf = mysql_query("SELECT divname, divid FROM sportsdb_divs WHERE conference = $confid ORDER BY divorder"); $numconf = mysql_num_rows($resultconf); if ($numconf == 0) die ("No data in this division"); while ($divs = mysql_fetch_array($resultconf, MYSQL_ASSOC)) { // Loop through each division $divname = $divs['divname']; print "<h3><font color='#1c19a0'>$divname</font></h3>\n"; ?> <table width='100%' class='tbl-border'> <tr><td class='tbl2' width='55%'><?php if ($standings_sort != 1) print "<a href=\"index.php?conf=$confid&sort=1\">"; ?><b>Team Name</b><?php if ($standings_sort != 1) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 6) print "<a href=\"index.php?conf=$confid&sort=6\">"; ?><strong>GP</strong><?php if ($standings_sort != 2) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 2) print "<a href=\"index.php?conf=$confid&sort=2\">"; ?><b>W</b><?php if ($standings_sort != 2) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 3) print "<a href=\"index.php?conf=$confid&sort=3\">"; ?><b>L</b><?php if ($standings_sort != 3) print "</a>"; ?></td> <?php if ($show_ties) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 4) print "<a href=\"index.php?conf=$confid&sort=4\">"; ?><b>T</b><?php if ($standings_sort != 4) print "</a>"; ?></td> <?php } ?> <?php if ($forfeit) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 5) print "<a href=\"index.php?conf=$confid&sort=5\">"; ?><b>Forfeits</b><?php if ($standings_sort != 5) print "</a>"; ?></td> <?php } ?> <?php if ($show_rfra) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 7) print "<a href=\"index.php?conf=$confid&sort=7\">"; ?><b>GF</b><?php if ($standings_sort != 7) print "</a>"; ?></td> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != print "<a href=\"index.php?conf=$confid&sort=8\">"; ?><b>GA</b><?php if ($standings_sort != print "</a>"; ?></td> <?php } ?> <?php if ($show_gb) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 9) print "<a href=\"index.php?conf=$confid&sort=9\">"; ?><b>GB</b><?php if ($standings_sort != 9) print "</a>"; ?></td> <?php } ?> <td class='tbl2' align='center' width='10%'><?php if ($standings_sort != 0) print "<a href=\"index.php?conf=$confid&sort=0\">"; ?><b>PCT</b><?php if ($standings_sort != 0) print "</a>"; ?></td> <?php if ($show_points) { ?> <td class='tbl2' align='center' width='5%'><?php if ($standings_sort != 10) print "<a href=\"index.php?conf=$confid&sort=10\">"; ?><b>Pts</b><?php if ($standings_sort != 10) print "</a>"; ?></td> <?php } ?> </tr> <?php $query = "SELECT COUNT(*) FROM sportsdb_teams WHERE teamdiv = {$divs['divid']}"; $result = mysql_query($query); $result_exist = mysql_result($result,0); if ($result_exist) { $query = "SELECT teamid, teamname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra, (teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed, (teamwins / (teamwins + teamlosses + teamforfeits)) AS winningpct, (teamwins - teamlosses - teamforfeits) AS leadervalue, (teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points FROM sportsdb_teams WHERE teamdiv = {$divs['divid']} ORDER BY leadervalue DESC, teamties DESC LIMIT 1"; $result = mysql_query($query) or die ("Error in query: $query"); $results = mysql_fetch_array($result, MYSQL_ASSOC); $winningpct=number_format($results['winningpct'], 3); } // Show the leader at the top for default sorting (games behind) if ($standings_sort == 9) { print "<tr><td class='tbl1' width='55%'><em>{$results['teamname']}</em></td><td class='tbl1' align='center' width='5%'>{$results['gamesplayed']}</td><td class='tbl1' align='center' width='5%'>{$results['teamwins']}</td><td class='tbl1' align='center' width='5%'>{$results['teamlosses']}</td>"; if ($show_ties) print "<td class='tbl1' align='center' width='5%'>{$results['teamties']}</td>"; if ($forfeit) print "<td class='tbl1' align='center' width='5%'>{$results['teamforfeits']}</td>"; if ($show_rfra) print "<td align='center' class='tbl1' width='5%'>{$results['teamrf']}</td><td align='center' class='tbl1' width='5%'>{$results['teamra']}</td>"; if ($show_gb) print "<td class='tbl1' align='center' width='5%'>---</td>"; print "<td class='tbl1' align='center' width='10%'>$winningpct</td>"; if ($show_points) print "<td class='tbl1' align='center' width='5%'>{$results['points']}</td>"; print "</tr>\n"; } if ($result_exist) { $query="SELECT teamid, teamname, teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra, (teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed, (teamwins / (teamwins + teamlosses + teamforfeits)) AS winningpct, ((({$results['leadervalue']}) - (teamwins - teamlosses - teamforfeits)) / 2) AS gamesbehind, (teamwins * $points_win + teamforfeits * $points_forfeit + teamties * $points_tie) AS points FROM sportsdb_teams WHERE teamdiv = {$divs['divid']}"; if ($standings_sort == 9) { $query .= " AND teamid != {$results['teamid']}"; } $query .= " AND active = 1" . $division_sort . " ORDER BY $sort_order"; $result=mysql_query($query); $num=mysql_numrows($result); while ($results = mysql_fetch_array($result, MYSQL_ASSOC)) { $winningpct=number_format($results['winningpct'], 3); $gamesbehind = number_format($results['gamesbehind'],1); if ($gamesbehind == "0.0") $gamesbehind = "---"; print "<tr><td class='tbl1'><em>{$results['teamname']}</em></td><td class='tbl1' align='center'>{$results['gamesplayed']}</td><td class='tbl1' align='center'>{$results['teamwins']}</td><td class='tbl1' align='center'>{$results['teamlosses']}</td>"; if ($show_ties) print "<td class='tbl1' align='center'>{$results['teamties']}</td>"; if ($forfeit) print "<td class='tbl1' align='center'>{$results['teamforfeits']}</td>"; if ($show_rfra) print "<td class='tbl1' align='center'>{$results['teamrf']}</td><td class='tbl1' align='center'>{$results['teamra']}</td>"; if ($show_gb) print "<td class='tbl1' align='center'>$gamesbehind</td>"; print "<td class='tbl1' align='center'>$winningpct</td>"; if ($show_points) print "<td class='tbl1' align='center'>{$results['points']}</td>"; print "</tr>\n"; } } print "</table> <table width='100%' class='tbl-border'><tr><td bgcolor='#FFFF00'>Results and Standings are not kept for Ages U-7 through U-10. The focus is on learning the game, playing safe, and HAVING FUN!</td></tr></table>\n"; } ?> <form name="teamsort" method="post" action="<?php print $_SERVER['REQUEST_URI']; ?>"> <p>Show only <select name="teamtosort"> <option value="all">All teams</option> <?php $queryteams = "SELECT sportsdb_teams.teamname, sportsdb_teams.teamid FROM sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid ORDER BY teamname"; $resultteams=mysql_query($queryteams); $numteams=mysql_numrows($resultteams); while ($teams = mysql_fetch_array($resultteams, MYSQL_ASSOC)) { print "<option value=\"{$teams['teamid']}\""; if ($teams['teamid'] == $_POST['teamtosort']) print ' selected'; print ">{$teams['teamname']}</option>\n"; } ?> </select> <input type="submit" value="Go" /> </p> </form> <h3><font color='#1c19a0'>Upcoming Games</font></h3> <?php print "<table width='100%' class='tbl-border'>\n"; print "<tr><th class='tbl2'>Status</th><th class='tbl2'>Date</th><th class='tbl2'>Time</th><th class='tbl2'>Home Team</th><th class='tbl2'>Visiting Team</th>"; if ($show_fields) print "<th class='tbl2'>Field</th>"; $queryscores = "SELECT sportsdb_wins.winid, sportsdb_wins.status, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.game_date, sportsdb_wins.game_time, sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.field_no, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie = 3"; // Sort by team if specified if (isset($_POST['teamtosort']) && $_POST['teamtosort'] != 'all') { $teamtosort = intval($_POST['teamtosort']); $queryscores .= " AND (sportsdb_wins.winner = $teamtosort OR sportsdb_wins.loser = $teamtosort)"; } $queryscores .= " ORDER BY game_date ASC, game_time ASC"; $resultscores = mysql_query($queryscores); $numscores = mysql_numrows($resultscores); while ($scores = mysql_fetch_array($resultscores, MYSQL_ASSOC)) { $game_time = ($scores['game_time']!=null)?date("g:i a", strtotime($scores['game_time'])):'TBA'; $game_date = ($scores['game_date']!=null)?date("l, F j",strtotime($scores['game_date'])):'* TBA *'; //$windateheader=$scores['windate']; //$windateformatted=date("F d, Y",$windateheader); //$wintime=$scores['wintime']; //$hour=date('g',$wintime); //$minute=date('i',$wintime); //$ampm=date('a',$wintime); print "<tr><td class='tbl1'>{$scores['status']}</td><td class='tbl1'>$game_date</td><td class='tbl1'>$game_time</td><td class='tbl1'>{$scores['winningteam']}</td><td class='tbl1'>{$scores['losingteam']}</td>"; if ($show_fields) print "<td class='tbl1'>{$scores['field']} {$scores['field_no']}</td>"; } echo "</table>\n"; ?> <h3><font color='#1c19a0'>Past Scores</font></h3> <?php print "<table width='100%' class='tbl-border'>\n"; print "<tr><th class='tbl2'>Date</th><th class='tbl2'>Home Team</th><th class='tbl2'>Score</th><th class='tbl2'>Visiting Team</th><th class='tbl2'>Score</th>"; if ($show_fields) print "<th class='tbl2'>Field</th>\n"; $queryscores="SELECT sportsdb_wins.winid, sportsdb_wins.windate, sportsdb_wins.wintime, sportsdb_wins.game_date, sportsdb_wins.game_time, sportsdb_wins.rf, sportsdb_wins.ra, sportsdb_wins.wincomments, sportsdb_wins.field, sportsdb_wins.winortie, sportsdb_teams2.teamname AS winningteam, sportsdb_teams.teamname AS losingteam FROM sportsdb_wins, sportsdb_teams AS sportsdb_teams2, sportsdb_teams, sportsdb_divs WHERE sportsdb_teams.teamdiv = sportsdb_divs.divid AND sportsdb_divs.conference = $confid AND sportsdb_teams2.teamid = sportsdb_wins.winner AND sportsdb_teams.teamid = sportsdb_wins.loser AND sportsdb_wins.winortie != 3"; // Sort by team if specified if (isset($_POST['teamtosort']) && $_POST['teamtosort'] != 'all') { $teamtosort = intval($_POST['teamtosort']); $queryscores .= " AND (sportsdb_wins.winner = $teamtosort OR sportsdb_wins.loser = $teamtosort)"; } $queryscores .= " ORDER BY wintime ASC"; $resultscores=mysql_query($queryscores); $numscores=mysql_numrows($resultscores); while ($scores = mysql_fetch_array($resultscores, MYSQL_ASSOC)) { $game_time = ($scores['game_time']!=null)?date("g:i a", strtotime($scores['game_time'])):'TBA'; $game_date = ($scores['game_date']!=null)?date("l, F j",strtotime($scores['game_date'])):'* TBA *'; //$windateheader=$scores['windate']; //$windateformatted=date("F d, Y",$windateheader); //$wintime=$scores['wintime']; //$hour=date('g',$wintime); //$minute=date('i',$wintime); //$ampm=date('a',$wintime); print "<tr><td class='tbl1'>$game_date</td><td class='tbl1'>{$scores['winningteam']}</td>"; print "<td class='tbl1' align='center'><b>{$scores['rf']}</b></td> <td class='tbl1'>{$scores['losingteam']}</td>"; print "<td class='tbl1' align='center'><b>{$scores['ra']}</b></td>"; if ($show_fields) print "<td class='tbl1'>{$scores['field']}</td>"; if ($scores['winortie'] == 2 || $scores['winortie'] == 5) print " (ff)"; print "</td></tr>\n"; } echo "</table>\n"; closetable (); } // List the conference else { opentable ("Spring 2008 Season"); print "<p>Click on the division name to view its schedules, results (U-11 & older), and standings (U-11 & older).</p> <table align='center' border='1' id='table2' cellspacing='0' cellpadding='3'> <tr> <td bgcolor='#FFFF00'><font face='Arial' size='4'><b>NOTE:</b></font><p> <font face='Arial' size='2'>Results and Standings are not kept for Ages U-7 through U-10. The focus is on learning the game, playing safe, and HAVING FUN!</font></td> </tr> </table><br>\n"; $query = "SELECT * FROM sportsdb_conferences ORDER BY conforder"; $result = mysql_query($query) or die("Error in query $query"); $num = mysql_num_rows($result); while ($confs = mysql_fetch_array($result, MYSQL_ASSOC)) { print " <a href=\"index.php?conf={$confs['confid']}\">{$confs['confname']}</a><br>\n"; } closetable (); } require_once "../side_right.php"; require_once "../footer.php"; ?> For our standing, we do not keep records and standings for certain young ages (confid < 12). How can I include an if statement to not display the standings table for confid < 12? Currently the table to displayed for all, with a highlighted statement stating that the certain standings are not kept. Assistance is greatly appreciated.
-
Thanks. I did find a working script while Googling. <?php $host = 'localhost'; $user = 'mysqlUser'; $pass = 'myUserPass'; $db = 'myDatabase'; $table = 'products_info'; $file = 'export'; $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error()); mysql_select_db($db) or die("Can not connect."); $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $csv_output .= $row['Field'].", "; $i++; } } $csv_output .= "\n"; $values = mysql_query("SELECT * FROM ".$table.""); while ($rowr = mysql_fetch_row($values)) { for ($j=0;$j<$i;$j++) { $csv_output .= $rowr[$j].", "; } $csv_output .= "\n"; } $filename = $file."_".date("Y-m-d_H-i",time()); header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header( "Content-disposition: filename=".$filename.".csv"); print $csv_output; exit; ?>
-
How can I code to export a table to Excel (or cvs file)? I have my youth sports schedule that I am repeatedly asked to send as Excel file. I want to have a link for my members to download to Excel (preferred, but can settle for cvs file). Assistance is greatly appreciated.
-
I thought I might by in the right direction with: <form name='reportform' method='post' action='".FUSION_SELF."> <table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td colspan='8' bgcolor='#FFFF00'> <p style='margin-top: 0; margin-bottom: 0'><font size='2'>Below is a list of games scheduled at your club/district's home fields. To add Times and Field Specifics, click "<font color='#FF0000'>Edit</font>" next to the corresponding game. </td></tr> <tr> <td><b><font size='1'>Division:</font></b></td> <td><b><font size='1'>Game ID:</font></b></td> <td><b><font size='1'>Date:</font></b></td> <td><b><font size='1'>Time/Notes:</font></b></td> <td><b><font size='1'>Time:</font></b></td> ".(checkrights("A") ? "<td><b><font size='1'>Off. Time:</font></b></td>" : "")." <td><b><font size='1'>Teams:</font></b></td> <td><b><font size='1'>Field:</font></b></td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; if ($data['game_date'] != $prev) { // if division changed echo "<tr><td colspan='3'> </td></tr>\n"; // blank row $prev = $data['game_date']; } echo "<tr> <td class='$tclass'><font size='1'>".$data['s08div']."</font></td> <td class='$tclass'><font size='1'>".$data['game_id']."</font></td> <td class='$tclass'><font size='1'>".$data['game_date']=date("D, M j, Y",strtotime($data['game_date']))."</font></td> <td class='$tclass'><font size='1'><span style='background-color: #FFFF00'>".$data['notes']."</span></font></td> <td class='$tclass'><font color='#0000FF' size='1'><input type='text' name='time_text' value='".$data['time_text']."' class='textbox' style='width:75px;'></font></td> ".(checkrights("A") ? "<td class='$tclass'><font color='#0000FF' size='1'><input type='text' name='game_time' value='".$data['game_time']."' class='textbox' style='width:75px;'></font></td>" : "")." <td class='$tclass'> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['home_team']." vs.</font></p> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['visit_team']."</font></font></td> <td class='$tclass'><font color='#0000FF' size='1'><input type='text' name='field' value='".$data['field']."' class='textbox' style='width:150px;'> <input type='text' name='field_no' value='".$data['field_no']."' class='textbox' style='width:100px;'></font></td> </tr>\n"; } echo "<tr> <td align='center' colspan='8'> <input type='submit' name='edit_sched' value='".$locale['sched135']."' class='button'></td> </tr> </table> </form> But, I did not even get the records to display. Assistance is greatly appreciated.
-
The current script works fine, but I would like to make it more user friendly and less tedious. I am stuck at the <form>, changing from single entry to multiple entries. I want it to list all records with <inputs> for time field all in one table. The Submit would update all records.
-
I run a youth sports website and write their schedules. I have a php script that I implimented that allows club field schedulers to add times into games at their fields. Currently, it allows editting of each record (game) individually. I would like to make it easier for those schedulers to enter times into all games in one simple form process. I am wondering how to change it so that all records can be displayed and edited on one page, in one submission (like the attached image). My current scheduling.php file is: <?php require_once "../maincore.php"; require_once "../subheader.php"; require_once "../side_left.php"; include LOCALE.LOCALESET."sched.php"; //if (!checkrights("FS")) fallback("../index.php"); if (isset($_POST['edit_sched'])) { $time = stripinput($_POST['time']); $time_text = stripinput($_POST['time_text']); $game_time = stripinput($_POST['game_time']); $home_field = stripinput($_POST['field']); $field_no = stripinput($_POST['field_no']); $result = dbquery("UPDATE scheduless SET sched_user='".$userdata['user_id']."', time_text='$time_text', game_time='$game_time', field='$field', field_no='$field_no' WHERE game_id='$game_id' "); //$result = dbquery("UPDATE ".$db_prefix."faq_cats SET faq_cat_name='$faq_cat_name' WHERE faq_cat_id='$faq_cat_id'"); } if ($step == "edit"){ //$data = dbarray(dbquery( // "SELECT ter.*, user_id,user_name FROM scheduless ter // LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id // WHERE game_id='$game_id'" // )); $data = dbarray(dbquery("SELECT * FROM schedules WHERE game_id='$game_id'")); // note change here $display_time = date("g:i a", strtotime($data['time'])); opentable ($locale['sched001']); echo "<form name='reportform' method='post' action='".FUSION_SELF."?game_id=$game_id'> ".$locale['sched120']." <table align='center' cellspacing='5' cellpadding='5' class='tbl' width='375'> <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Division:</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'>".$data['s08div']."</p> </td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Game ID:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['game_id']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Date:</b></td> <td width=216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['game_date']=date("D, M j, Y",strtotime($data['game_date']))."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Time/Notes:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'> <span style='background-color: #FFFF00'>".$data['notes']."</span></td> </tr> ".(checkrights("A") ? "<tr> <td valign='top' width='124' bgcolor='#C0C0C0'> <p style='margin-top: 0; margin-bottom: 0'><b>Official Time:</b></td> <td valign='top' width='216' bgcolor='#C0C0C0'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='game_time' value='".$data['game_time']."' class='textbox' style='width:75px;'></td> </tr>" : "")." <tr> <td valign='top' width='124'> <p style='margin-top: 0; margin-bottom: 0'><b>Time</b></td> <td valign='top' width='216'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='time_text' value='".$data['time_text']."' class='textbox' style='width:75px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Match-up:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'>".$data['home_team']."</p> <p style='margin-top: 0; margin-bottom: 0'><font color='#0000FF'>vs.</font> ".$data['visit_team']."</td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field' value='".$data['field']."' class='textbox' style='width:150px;'></td> </tr> <tr> <td width='124' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><b>Field # or Name:</b></td> <td width='216' valign='top'> <p style='margin-top: 0; margin-bottom: 0'><input type='text' name='field_no' value='".$data['field_no']."' class='textbox' style='width:100px;'></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' name='edit_sched' value='".$locale['sched135']."' class='button'></td> </tr> </table> </form>\n"; closetable (); } opentable ($locale['sched001']); $sql = dbquery( "SELECT ter.*, user_id,user_name FROM schedules ter LEFT JOIN ".$db_prefix."users tusr ON ter.sched_user=tusr.user_id ORDER BY game_date ASC,game_time ASC" ); // note change here $display_time = date("g:i a", strtotime($data['time'])); if (dbrows($sql)) { $i = 0; echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td colspan='9' bgcolor='#FFFF00'> <p style='margin-top: 0; margin-bottom: 0'><font size='2'>Below is a list of games scheduled at your club/district's home fields. To add Times and Field Specifics, click "<font color='#FF0000'>Edit</font>" next to the corresponding game.</td></tr> <tr> <td><b><font size='1'>Division:</font></b></td> <td><b><font size='1'>Game ID:</font></b></td> <td><b><font size='1'>Date:</font></b></td> <td><b><font size='1'>Time/Notes:</font></b></td> <td><b><font size='1'>Time:</font></b></td> ".(checkrights("A") ? "<td><b><font size='1'>Off. Time:</font></b></td>" : "")." <td><b><font size='1'>Teams:</font></b></td> <td><b><font size='1'>Field:</font></b></td> <td><b><font size='1'>Options:</font></b></td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; if ($data['game_date'] != $prev) { // if division changed echo "<tr><td colspan='3'> </td></tr>\n"; // blank row $prev = $data['game_date']; } echo "<tr> <td class='$tclass'><font size='1'>".$data['s08div']."</font></td> <td class='$tclass'><font size='1'>".$data['game_id']."</font></td> <td class='$tclass'><font size='1'>".$data['game_date']=date("D, M j, Y",strtotime($data['game_date']))."</font></td> <td class='$tclass'><font size='1'><span style='background-color: #FFFF00'>".$data['notes']."</span></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['time_text']."</font></td> ".(checkrights("A") ? "<td class='$tclass'><font color='#0000FF' size='1'>".$data['game_time']."</font></td>" : "")." <td class='$tclass'> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['home_team']." vs.</font></p> <p style='margin-top: 0; margin-bottom: 0'><font size='1'>".$data['visit_team']."</font></font></td> <td class='$tclass'><font color='#0000FF' size='1'>".$data['field']." ".$data['field_no']."</font></td> <td class='$tclass'><center><a href='".FUSION_SELF."?step=edit&game_id=".$data['game_id']."'> <font size='1'>".$locale['sched002']."</font></a></center></td> </tr>\n"; } echo "</table>\n"; } else { echo "<center><br>\n".$locale['sched141']."<br><br>\n</center>\n"; } closetable(); echo "</td>\n"; require_once BASEDIR."footer.php"; ?> Any suggestions?
-
[SOLVED] display breaks in table classifications
kemper replied to kemper's topic in PHP Coding Help
how do I do that? -
If my table has a structure like: Division Team A Team 1 A Team 2 A Team 8 A Team 9 B Team 3 B Team 4 B Team 6 B Team 7 How can I change my script of: <table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td class='tbl2'><b>Division</b></td> <td class='tbl2'><b>Team</b></td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; echo "<tr> <td class='$tclass'><font size='1'>".$data['f07div']."</font></td> <td class='$tclass'> <font size='1'>".$data['Team']."</font></td> </tr>\n"; } echo "</table> To display some type of break between each division?
-
The problem was not the javascript, but your other post helped. Thanks! ... ?> <SCRIPT LANGUAGE="JavaScript"> Blah, Blah, Blah <?php ... Did the trick!
-
No errors, just javascript not running. It is only supposed to allow 6 dates to be chosen. On 7th selection, "alert("Oops! You can only choose up to " + max + " conflicts! \nUncheck a date if you want to pick another.");" should be pop up.
-
My javascript is not working. What am I doing wrong? <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF); opentable ("Spring 2008 Registration"); <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function countChoices(obj) { max = 6; // max. number allowed at a time Sept8 = obj.form.Sept8.checked; Sept9 = obj.form.Sept9.checked; Sept15 = obj.form.Sept15.checked; Sept16 = obj.form.Sept16.checked; Sept22 = obj.form.Sept22.checked; Sept23 = obj.form.Sept23.checked; Sept29 = obj.form.Sept29.checked; Sept30 = obj.form.Sept30.checked; Oct6 = obj.form.Oct6.checked; Oct7 = obj.form.Oct7.checked; Oct13 = obj.form.Oct13.checked; Oct14 = obj.form.Oct14.checked; Oct20 = obj.form.Oct20.checked; Oct21 = obj.form.Oct21.checked; Oct27 = obj.form.Oct27.checked; Oct28 = obj.form.Oct28.checked; count = (Sept8 ? 1 : 0) + (Sept9 ? 1 : 0) + (Sept15 ? 1 : 0) + (Sept16 ? 1 : 0) + (Sept22 ? 1 : 0) + (Sept23 ? 1 : 0) + (Sept29 ? 1 : 0) + (Sept30 ? 1 : 0) + (Oct6 ? 1 : 0) + (Oct7 ? 1 : 0) + (Oct13 ? 1 : 0) + (Oct14 ? 1 : 0) + (Oct20 ? 1 : 0) + (Oct21 ? 1 : 0) + (Oct27 ? 1 : 0) + (Oct28 ? 1 : 0); if (count > max) { alert("Oops! You can only choose up to " + max + " conflicts! \nUncheck a date if you want to pick another."); obj.checked = false; } } // End --> </script> echo "<form enctype='multipart/form-data' action='processs08reg.php' method='POST'> <table border='1' cellspacing='1' style='border-width:0px; border-collapse: collapse; ' bordercolor='#000066' width='100%' cellpadding='5'> <tr> <td height='30' width='100%' bordercolor='#000000' colspan='2' style='border-left-color: #000066; border-left-width: 1px; border-right-color: #000066; border-right-width: 1px; border-top-color: #000066; border-top-width: 1px' bgcolor='#1B179F'> <blockquote> <blockquote> <blockquote> <P align='center' style='margin-top: 0; margin-bottom: 0'><b> <font color='#FFFFFF'>This form is past due and must be completed prior to 11:59 pm on Tuesday, January 15, 2008.</font></b></P> </blockquote> </blockquote> </blockquote> <P align='center' style='margin-top: 0; margin-bottom: 0'><b> <font color='#FFFFFF'>Thank you.</font></b></P> <p style='margin-top: 0; margin-bottom: 0'><font color='#FFFFFF'> </font></td> </tr> <tr> <td height='30' width='100%' bordercolor='#000000' colspan='2' style='border-left-color: #000066; border-left-width: 1px; border-right-color: #000066; border-right-width: 1px; border-top-color: #000066; border-top-width: 1px' bgcolor='#C0C0C0'> <b> All fields marked with <font color='#0000FF'>* </font> are required fields.</b></td> </tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> Club:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'><font face='Arial'><select name='Club'><option value='Select One'>Select One:<option value='Club A'>Club A<option value='Club B'>Club B<option value='Club C'>Club C<option value='Other - add $25 Non-District Fee'>Other Club: (Please specify below, add $25 Non-District Fee)</select></font></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <p align='right'> Other (Non-Metro District) Club:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'> <input type=text name='OtherClub' size=20></font> <font color='#ff0000'>< add $25 Non-District Fee</font></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> Team Name:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'><font color='#FF0000' face='Arial'><input type=text name='Team' size=30></font></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td height='30' width='1008' bordercolor='#000000' style='border-left: 1px solid #000066; border-right: 1px solid #000066; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium' colspan='2' bgcolor='#FF0000'> <font color='#FFFFFF'> <b>Conflicts (You may select up to Six Dates Only):</b></font></td> </tr><tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium' colspan='2'> <table border='0' cellpadding='0' style='border-collapse: collapse' width='100%' id='table3'> <tr> <td bgcolor='#FF6666' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' colspan='5'> <b> Sanctioned Tournaments (for reference only)</b></td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 8</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept8 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept9 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 9</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 15</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept15 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept16 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 16</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 22</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept22 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept23 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 23</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 29</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept29 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept30 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> September 30</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 6</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct6 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct7 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 7</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 13</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct13 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct14 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 14</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 20</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct20 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct21 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 21</td> </tr> <tr> <td width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Saturday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 27</td> <td width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct27 onClick='countChoices(this)' value='X'></td> <td valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><span class='style114'> <span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span><p style='margin-top: 0; margin-bottom: 0'> <span class='style114'><span style='font-weight: 400'> <font color='#000000'> Tournament</font></span></span></td> <td width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct28 onClick='countChoices(this)' value='X'></td> <td width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> Sunday,</p> <p style='margin-top: 0; margin-bottom: 0'> October 28</td> </tr> <tr> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' colspan='5' bgcolor='#FFFF00'> <p align='left'><span style='COLOR: black; '> * Please plan to play on all weekend dates not checked on the above list.</span></td> </tr> </table> </td> </tr> <tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium' colspan='2' bgcolor='#FF0000'> <b> <font color='#FFFFFF'>NOTE:</font></b></td> </tr><tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium' colspan='2'> <p align='left'> <span style='color:red'>The league will not allow any game changes after Tuesday, January 15, 2008 (per league rule stated below). Please plan to play on all weekend dates <u>not</u> included on your block-out list (above).</span></p> <p class='MsoNormal' style='margin-right:-12.0pt'> <u>League Rule #5</u> Game Changes </p> <p class='p1' style='margin:0in;margin-bottom:.0001pt'> All games are to be played at the scheduled place and time. ****** will not approve any game changes. This means that on the scheduled game date, a score for that game must be reported or each team will be charged with a forfeit of the game. <i> Inclement weather is the only approved reason for game rescheduling. * Participation in additional tournaments (tournaments not given on Registration Form or Conflict Form) is not acceptable for League Game(s) change. These league games will result in a forfeit and fines will be accessed, if team does not show.</i></p> </td> </tr><tr> <td height='30' width='1199' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:solid; border-right-width:1px; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium' colspan='2'> <font face='Arial'><input type=checkbox name='Rules' value='Yes'></font> <b> <font color='#FF0000'> *</font></b> I have read & understand the ****** policy regarding Game Changes.</td> </tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> Person completing form:</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font color='#FF0000' face='Arial'><input type=text name='Signed' size=30></font></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> Person's Duties with above mentions team:</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font color='#FF0000' face='Arial'><input type=text name='Duties' size=20></font></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> Contact Phone (###-###-###):</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font color='#FF0000' face='Arial'><input type=text name='ContactPhone' size=10></font></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium'> email:</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium'> <font color='#FF0000' face='Arial'><input type=text name='email' size=30></font><b><font color='#FF0000'> *</font></b></td></tr><tr> <td colspan='2' height='25' width='100%' style='border-left:medium none #000066; border-right:medium none #000066; border-bottom:medium none #000066; border-top-style:solid; border-top-width:1px' bordercolor='#000000'> <p align='center' style='margin-bottom: 0'> <font color='#1B179F'>Credit Cards are <u>NOT</u> accepted. Once registration is received, an invoice will be sent to the person completing this form. Payment will be required within 14 days of the date of invoice.</font><p align='center'> <font face='Arial' size='2'><input type=submit value='Submit'></font> <font face='Arial' size='2'><input type=reset value='Reset'></font></td></tr> </table></form>\n"; closetable(); require_once "side_right.php"; require_once "footer.php"; ?>
-
So... Should I just separate out the Javascript? Like: <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; if (!checkrights("FR")) fallback("../index.php"); ?> <SCRIPT LANGUAGE='JavaScript'> <!-- Begin function countChoices(obj) { max = 6; // max. number allowed at a time Sept8 = obj.form.Sept8.checked; Sept9 = obj.form.Sept9.checked; Sept15 = obj.form.Sept15.checked; Sept16 = obj.form.Sept16.checked; Sept22 = obj.form.Sept22.checked; Sept23 = obj.form.Sept23.checked; Sept29 = obj.form.Sept29.checked; Sept30 = obj.form.Sept30.checked; Oct6 = obj.form.Oct6.checked; Oct7 = obj.form.Oct7.checked; Oct13 = obj.form.Oct13.checked; Oct14 = obj.form.Oct14.checked; Oct20 = obj.form.Oct20.checked; Oct21 = obj.form.Oct21.checked; Oct27 = obj.form.Oct27.checked; Oct28 = obj.form.Oct28.checked; count = (Sept8 ? 1 : 0) + (Sept9 ? 1 : 0) + (Sept15 ? 1 : 0) + (Sept16 ? 1 : 0) + (Sept22 ? 1 : 0) + (Sept23 ? 1 : 0) + (Sept29 ? 1 : 0) + (Sept30 ? 1 : 0) + (Oct6 ? 1 : 0) + (Oct7 ? 1 : 0) + (Oct13 ? 1 : 0) + (Oct14 ? 1 : 0) + (Oct20 ? 1 : 0) + (Oct21 ? 1 : 0) + (Oct27 ? 1 : 0) + (Oct28 ? 1 : 0); if (count > max) { alert('Oops! You can only choose up to ' + max + ' conflicts! \nUncheck a date if you want to pick another.'); obj.checked = false; } } // End --> </script> <?php opentable (Fall 2007/Spring 2008 Registration); ... This is not working. I am getting:
-
Opening another PHP block at the end of the page before the "echo" at the bottom doesn't seem to be the complete solution because I also get: above my form and: at the end. What do I do?
-
OK. It somewhat worked. The problem now is that formatting was screwed up. The subheader stretched only across top of side_left and main text area. The right side aligned all the way to the top of the page instead to the subheader.
-
No change there!
-
I am using a form for team registration into our league. The form I was going to use was giving me errors. The code is below. The error I am receiving is: What did I do wrong? <?php require_once "maincore.php"; require_once "subheader.php"; require_once "side_left.php"; if (!checkrights("FR")) fallback("../index.php"); <SCRIPT LANGUAGE='JavaScript'> <!-- Begin function countChoices(obj) { max = 6; // max. number allowed at a time Sept8 = obj.form.Sept8.checked; Sept9 = obj.form.Sept9.checked; Sept15 = obj.form.Sept15.checked; Sept16 = obj.form.Sept16.checked; Sept22 = obj.form.Sept22.checked; Sept23 = obj.form.Sept23.checked; Sept29 = obj.form.Sept29.checked; Sept30 = obj.form.Sept30.checked; Oct6 = obj.form.Oct6.checked; Oct7 = obj.form.Oct7.checked; Oct13 = obj.form.Oct13.checked; Oct14 = obj.form.Oct14.checked; Oct20 = obj.form.Oct20.checked; Oct21 = obj.form.Oct21.checked; Oct27 = obj.form.Oct27.checked; Oct28 = obj.form.Oct28.checked; count = (Sept8 ? 1 : 0) + (Sept9 ? 1 : 0) + (Sept15 ? 1 : 0) + (Sept16 ? 1 : 0) + (Sept22 ? 1 : 0) + (Sept23 ? 1 : 0) + (Sept29 ? 1 : 0) + (Sept30 ? 1 : 0) + (Oct6 ? 1 : 0) + (Oct7 ? 1 : 0) + (Oct13 ? 1 : 0) + (Oct14 ? 1 : 0) + (Oct20 ? 1 : 0) + (Oct21 ? 1 : 0) + (Oct27 ? 1 : 0) + (Oct28 ? 1 : 0); if (count > max) { alert('Oops! You can only choose up to ' + max + ' conflicts! \nUncheck a date if you want to pick another.'); obj.checked = false; } } // End --> </script> <style> <!-- .style114 {font-family: Verdana; font-size: 11px; color: #FF0000; font-weight: bold; } --> </style> opentable (Fall 2007/Spring 2008 Registration); //echo '<form enctype='multipart/form-data' action='processf07reg.php' method='POST'> <table border='1' cellspacing='1' style='border-width:0px; border-collapse: collapse; ' bordercolor='#000066' width='100%' cellpadding='5'> <tr> <td height='30' width='100%' bordercolor='#000000' colspan='2' style='border-left-color: #000066; border-left-width: 1px; border-right-color: #000066; border-right-width: 1px; border-top-color: #000066; border-top-width: 1px' bgcolor='#1B179F'> <blockquote> <blockquote> <blockquote> <P align='center' style='margin-top: 0; margin-bottom: 0'><b> <font size='5' face='Arial' color='#FFFFFF'>This form must be completed prior to 11:59 pm on June 15, 2007.</font></b></P> </blockquote> </blockquote> </blockquote> <P align='center' style='margin-top: 0; margin-bottom: 0'><b> <font size='5' face='Arial' color='#FFFFFF'>Thank you.</font></b></P> <p style='margin-top: 0; margin-bottom: 0'><font size='1' color='#FFFFFF'> </font></td> </tr> <tr> <td height='30' width='100%' bordercolor='#000000' colspan='2' style='border-left-color: #000066; border-left-width: 1px; border-right-color: #000066; border-right-width: 1px; border-top-color: #000066; border-top-width: 1px' bgcolor='#C0C0C0'> <b> <font size='2' face='Arial'> All fields marked with </font> <font color='#0000FF' size='4' face='Arial'>* </font> <font size='2' face='Arial'>are required fields.</font></b></td> </tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Arial' size='2'>Club:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'><font face='Arial'><select name='Club'><option value='Select One'>Select One:<option value='Club A'>Club A<option value='Club B'>Club B<option value='Other: (Please Specify Below and add $25 non-District Fee)'>Other Club: (Please specify below)</select></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <p align='right'> <font face='Arial' size='2'>Other (Non-Metro District) Club:</font></td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'> <font face='Arial' size='2'> </font><font face='Arial'><input type=text name='OtherClub' size=20> </font> <span style='FONT-FAMILY: Arial'><font color='#ff0000' size='2'>< add $25 Non-District Fee</font></span></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Arial' size='2'>Team Name:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'><font face='Arial'><input type=text name='Team' size=30></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Arial' size='2'>Age <font color='#FF0000'>(includes Base Fees)</font>:</td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium'> <font face='Verdana'><font face='Arial'><select name='Age'><option value='Select One:'>Select One:<option value='Girls U-8 ($90) New Team Registration'>Girls U-8 ($90) New Team Registration<option value='Girls U-9 ($90) New Team Registration'>Girls U-9 ($90) New Team Registration<option value='Girls U-10 ($90) New Team Registration'>Girls U-10 ($90) New Team Registration<option value='Girls U-11 ($125) New Team Registration'>Girls U-11 ($125) New Team Registration<option value='U-7 ($90) New Team Registration'>U-7 ($90) New Team Registration<option value='U-8 ($90) New Team Registration'>U-8 ($90) New Team Registration<option value='U-9 ($90) New Team Registration'>U-9 ($90) New Team Registration<option value='U-10 ($90) New Team Registration'>U-10 ($90) New Team Registration<option value='U-11 ($125) New Team Registration'>U-11 ($125) New Team Registration<option value='U-12 ($125) New Team Registration'>U-12 ($125) New Team Registration<option value='U-13 ($125) New Team Registration'>U-13 ($125) New Team Registration<option value='U-14 ($125) New Team Registration'>U-14 ($125) New Team Registration</select></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium'> <font face='Arial' size='2'>Division: </td> <td height='30' width='852' bordercolor='#000000' style='border-left-style: none; border-left-width: medium; border-right: 1px solid #000066; border-top-style: none; border-top-width: medium'> <font face='Verdana'><font face='Arial'><select name='Division'><option value='Select One:'>Select One:<option value='A (Highest)'>A (Highest)<option value='B'>B<option value='C'>C<option value='D (Lowest)'>D (Lowest)</select></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='1008' bordercolor='#000000' style='border-left: 1px solid #000066; border-right: 1px solid #000066; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium' colspan='2' bgcolor='#4c74b1'> <font color='#FFFFFF'> <b><font face='Arial' size='4'>Conflicts </font><font face='Arial' size='2'> (You may select up to Six Dates Only)</font><font face='Arial' size='4'>:</font></b></font></td> </tr><tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium' colspan='2'> <table border='0' cellpadding='0' style='border-collapse: collapse' width='100%' id='table3'> <tr> <td align='center' colspan='5' bordercolor='#FF6666' style='border-style: solid; border-width: 1px'> <p align='left'> <b> <span style='font-family:Arial;color:black'><font size='2'>For Fall 2</font></span><font size='2'><font face='Arial'><span style='font-family: ArialMT; color: black'>0</span></font><span style='font-family:Arial;color:black'>0</span><font face='Arial'><span style='font-family: ArialMT; color: black'>7</span></font><span style='font-family: Arial;color:black'>, each team may block out up to </span></font> <span style='font-family:Arial;color:black'><font size='2'>6 weekend days for tournaments and/or any other conflict. A weekend tournament will be considered 2 days worth of blackout dates.</font></span></b></td> </tr> <tr> <td align='center' bgcolor='#FF6666' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' colspan='5'><b> <font face='Arial' size='2' color='#FFFFFF'>WYSA Sanctioned Tournaments </font> <font face='Arial' size='1' color='#FFFFFF'>(for reference only)</font></b></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 8</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept8 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'>Tournament 1</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept9 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 9</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 15</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept15 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 2</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept16 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 16</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 22</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept22 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 3</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Sept23 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 23</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 29</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept29 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 4</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Sept30 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>September 30</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 6</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct6 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 5</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct7 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 7</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 13</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct13 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 6</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct14 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 14</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 20</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct20 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 7</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <input type=checkbox name=Oct21 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 21</font></td> </tr> <tr> <td align='center' width='185' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Saturday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 27</font></td> <td align='center' width='15' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct27 onClick='countChoices(this)' value='X'></td> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'><font face='Arial' size='2'> Tournament 8</font></td> <td align='center' width='15' valign='top' style='border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <input type=checkbox name=Oct28 onClick='countChoices(this)' value='X'></td> <td align='center' width='185' valign='top' style='border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' bgcolor='#CCCCCC'> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>Sunday,</font></p> <p style='margin-top: 0; margin-bottom: 0'> <font size='2' face='Arial' color='#1B179F'>October 28</font></td> </tr> <tr> <td align='center' valign='top' style='border-style: solid; border-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px' bordercolor='#FF6666' colspan='5' bgcolor='#FFFF00'> <p align='left'><span style='COLOR: black; FONT-FAMILY: Arial'> <font size='2'>* Please plan to play on all weekend dates not checked on the above list.</font></span></td> </tr> </table> </td> </tr> <tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: none; border-bottom-width: medium' colspan='2' bgcolor='#4c74b1'> <b> <font size='4' face='Arial' color='#FFFFFF'>NOTE:</font></b></td> </tr><tr> <td height='30' width='1200' bordercolor='#000000' style='border-left: 1px solid #000066; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium' colspan='2'> <p align='left'> <span style='font-family:Arial;color:red'><font size='2'>The league will not allow any game changes after June 15, 2007 (per league rule stated below). Please plan to play on all weekend dates <u>not</u> included on your block-out list (above).</font></span></p> <p class='MsoNormal' style='margin-right:-12.0pt'> <span style='font-family:Arial'><font size='2'> </font></span><u><span style='font-family:Arial'><font size='2'>League Rule #5</font></span></u><span style='font-family: Arial'><font size='2'> Game Changes </font> </span></p> <p class='p1' style='margin:0in;margin-bottom:.0001pt'> <span style='font-family:Arial'><font size='2'>All games are to be played at the scheduled place and time. Our League will not approve any game changes. This means that on the scheduled game date, a score for that game must be reported or each team will be charged with a forfeit of the game. </font> <i> <font size='2'>Inclement weather is the only approved reason for game rescheduling. * Participation in additional tournaments (tournaments not given on Registration Form or Conflict Form) is not acceptable for League Game(s) change. These league games will result in a forfeit and fines will be accessed, if team does not show.</font></i></span></p> </td> </tr><tr> <td height='30' width='1199' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:solid; border-right-width:1px; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium' colspan='2'> <font face='Arial'><input type=checkbox name='Rules' value='Yes'><font size='2'> </font> </font> <b> <font size='2' face='Arial'> </font><font color='#0000FF' size='4' face='Arial'>*</font></b><font size='2' face='Arial'> I have read & understand the Our League policy regarding Game Changes.</font></td> </tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Arial' size='2'>Person completing form:</font></td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font face='Arial'><input type=text name='Signed' size=30></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Arial' size='2'>Person's Duties with above mentions team:</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font face='Arial'><input type=text name='Duties' size=20></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Arial' size='2'>Contact Phone (###-###-###):</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium'> <font face='Verdana'><font face='Arial'><input type=text name='ContactPhone' size=10></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td height='30' width='348' bordercolor='#000000' style='border-left:1px solid #000066; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium'> <font face='Arial' size='2'>email:</td> <td height='30' width='852' bordercolor='#000000' style='border-right:1px solid #000066; border-left-style:none; border-left-width:medium; border-top-style:none; border-top-width:medium'> <font face='Verdana'><font face='Arial'><input type=text name='email' size=30></font></font><b><font size='2' face='Arial'> </font> <font color='#0000FF' size='4' face='Arial'>*</font></b></td></tr><tr> <td colspan='2' height='25' width='100%' style='border-left:medium none #000066; border-right:medium none #000066; border-bottom:medium none #000066; border-top-style:solid; border-top-width:1px' bordercolor='#000000'> <p align='center' style='margin-bottom: 0'> <p align='center'> <font face='Arial' size='2'><input type=submit value='Submit'> <input type=reset value='Reset'></font></td></tr> </table></form>\n"; } closetable(); echo "</td>\n"; require_once "side_right.php"; require_once BASEDIR."footer.php"; ?>
-
I operate a youth sports website and i display my current alignments in a long running list of teams (one field within my table) with association divisions (another field within table). I would like to group them by divisions, like a two column table for better clarification. Example: Division 1 Division 2 Team 1[br]Team 2[br]Team 3[br]Team 4[br]Team 5 Team 1[br]Team 2[br]Team 3[br]Team 4 [br][br] Division 3 Division 4 Team 1[br]Team 2[br]Team 3[br]Team 4 Team 1[br]Team 2[br]Team 3[br]Team 4[br]Team 5 [br][br] How do I modify my code??? $sql = dbquery( "SELECT ter.*, user_id,user_name FROM s2008_registrations ter LEFT JOIN ".$db_prefix."users tusr ON ter.reg_user=tusr.user_id ORDER BY s08div ASC, team ASC" ); if (dbrows($sql)) { $i = 0; echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'> <tr> <td class='tbl2' width='25%'>Division</td> <td class='tbl2' width='45%'>Team Name</td> </tr>\n"; while ($data = dbarray($sql)) { $i % 2 == 0 ? $tclass="tbl1" : $tclass="tbl2"; echo "<tr> <td class='$tclass' width='25%'><font size='1'>".$data['s08div']."</font></td> <td class='$tclass' width='45%'> <a href='".FUSION_SELF."?step=view&id=".$data['id']."'><font size='1'>".$data['team']."</font></a></td> </tr>\n"; } echo "</table>