ded Posted December 8, 2010 Share Posted December 8, 2010 This URL works fine: http://www.adodarts.com/calendarandresults/ This URL works fine: http://www.adodarts.com/calendarandresults/?year=2010®ion=&state= If I select 2009, it does not work: http://www.adodarts.com/calendarandresults/?year=2009®ion=&state= Here is the code: <script type="text/JavaScript"> <!-- function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } function poptastic(url) { newwindow=window.open(url,'name','height=400,width=525,scrollbars=yes,resizable=yes'); if (window.focus) {newwindow.focus()} } function poptastic1(url) { newwindow=window.open(url,'name','height=550,width=650,scrollbars=yes,resizable=yes'); if (window.focus) {newwindow.focus()} } //--> </script> <div align=center style="background-color:#66CCFF; font-size:18px; font-weight:bolder;"><a href="http://www.adodarts.com/files/ADOPlayoffInformation2010.pdf" target="_blank">Click here for 2010 ADO Playoff Information</a></div> <br> <div align=center style="background-color:#FFCC66; font-size:18px; font-weight:bolder;">Click below for 2010 ADO Regional Results</div> <div align=center style="background-color:#FFCC66; font-size:14px; font-weight:bolder;"><a href="2010-masters">MASTERS</a> - <a href="2010-all-stars">ALL-STARS</a> - <a href="2010-us-team"">US Team</a> - <a href="2010-cricket">Cricket</a></div> <table height=30> <tr><td> </td></td> </table> <form name="form1"> <table align=center> <tr> <td><select name="year" > <option value="">Year</option> <option value="2011">2011</option> <option value="2010">2010</option> <option value="2009">2009</option> </select> </td><td><select name="region"> <option value="">Region</option> <option value="">All Regions</option> <option value="1-1">Region 1-1</option> <option value="1-2">Region 1-2</option> <option value="1-3">Region 1-3</option> <option value="1-4">Region 1-4</option> <option value="1-5">Region 1-5</option> <option value="2-1">Region 2-1</option> <option value="2-2">Region 2-2</option> <option value="2-3">Region 2-3</option> <option value="2-4">Region 2-4</option> <option value="2-5">Region 2-5</option> <option value="3-1">Region 3-1</option> <option value="3-2">Region 3-2</option> <option value="3-3">Region 3-3</option> <option value="3-4">Region 3-4</option> <option value="3-5">Region 3-5</option> <option value="4-1">Region 4-1</option> <option value="4-2">Region 4-2</option> <option value="4-3">Region 4-3</option> <option value="4-4">Region 4-4</option> <option value="4-5">Region 4-5</option> <option value="4-6">Region 4-6</option> <option value="5-1">Region 5-1</option> <option value="5-2">Region 5-2</option> <option value="5-3">Region 5-3</option> <option value="5-4">Region 5-4</option> <option value="5-5">Region 5-5</option> <option value="6-1">Region 6-1</option> <option value="6-2">Region 6-2</option> <option value="6-3">Region 6-3</option> <option value="6-4">Region 6-4</option> <option value="6-5">Region 6-5</option> </select> </td><td><select name="state"> <option value="">State</option> <option value="">All States</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connectictut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Ketucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">New Hampshire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">West virginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select> </td><td> <input type="submit" value="Filter" onClick="MM_jumpMenu('parent',this,0)"> </td></tr> </table> <strong><em>*Note: Unsanctioned tournaments will not have links</em></strong> </form> <?php $year = $_GET['year']; $region = $_GET['region']; $state = $_GET['state']; if($year == 0) { $year = '2010'; } $dbh=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("adodarts_TournamentCalendar"); $y = "`sdate` >= '2010-01-01' AND `sdate` <= '2010-12-31'"; $r = ""; $s = ""; if($year == 2009) { $y = "`sdate` >= '2009-01-01' AND `sdate` <= '2009-12-31'"; } if($region != "") { $r = " and `region` = '" . $region . "'"; } if($state != "") { $s = " and `state` = '" . $state . "'"; } $query = "SELECT * FROM `ADOSanctionedTournaments` WHERE " . $y . $r . $s . " ORDER BY `sdate`"; $result = mysql_query($query,$dbh) or die(mysql_error()); ?> <table width=100% align=center> <?php while($row = mysql_fetch_array($result)) { $rrn = $row[rrn]; if(substr($row['sdate'],5,2) == 1) { $alphamonth = 'January'; } elseif(substr($row['sdate'],5,2) == 2) { $alphamonth = 'February'; } elseif(substr($row['sdate'],5,2) == 3) { $alphamonth = 'March'; } elseif(substr($row['sdate'],5,2) == 4) { $alphamonth = 'April'; } elseif(substr($row['sdate'],5,2) == 5) { $alphamonth = 'May'; } elseif(substr($row['sdate'],5,2) == 6) { $alphamonth = 'June'; } elseif(substr($row['sdate'],5,2) == 7) { $alphamonth = 'July'; } elseif(substr($row['sdate'],5,2) == { $alphamonth = 'August'; } elseif(substr($row['sdate'],5,2) == 9) { $alphamonth = 'September'; } elseif(substr($row['sdate'],5,2) == 10) { $alphamonth = 'October'; } elseif(substr($row['sdate'],5,2) == 11) { $alphamonth = 'November'; } elseif(substr($row['sdate'],5,2) == 12) { $alphamonth = 'December'; } if($alphamonth != $alphamonthhold) { echo "<tr><td colspan=5 align=center bgcolor=#CCCCCC>"; echo '<div style="color:#0000CC; font-size:14px; font-weight:bold">' . $alphamonth . '</div>'; echo "</td></tr>"; } echo "<tr><td align=center>"; echo substr($row['sdate'],8,2); if(substr($row['sdate'],8,2) != substr($row['edate'],8,2)) { echo "-" . substr($row['edate'],8,2) . " "; } echo "</td><td>"; if($row['filename'] != "" & $row['tournamentdirector'] == ""){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } elseif($row['filename'] != "" & $row['tournamentdirector'] != "" & $row['paymentreceived'] == "Y" & $row['adoapproved'] == "Y"){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } elseif($row['filename'] == "" & $row['tournamentdirector'] == "" & $row['paymentreceived'] == "Y" & $row['adoapproved'] == "Y"){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } else { echo $row['tournament']; } echo "<font color=white>" . $row[rrn] . "</font>"; echo "</td><td align=right>"; echo "$" . number_format($row['purse']); echo "</td><td>"; echo $row['state']; echo "</td><td>"; if($row['results'] != "Y") { echo " "; } else { echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/results.php?rrn=$rrn&year=$year');\">results</a>"; } echo "</td>"; $alphamonthhold = $alphamonth; } echo "</tr></table>"; ?> </td> </tr> </table> Quote Link to comment Share on other sites More sharing options...
ded Posted December 8, 2010 Author Share Posted December 8, 2010 It looks as though the options is null function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } Any thought on how to fix this? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.