Website Not Appearing on Certain onClick

ded · December 8, 2010

This URL works fine:

http://www.adodarts.com/calendarandresults/

This URL works fine:

http://www.adodarts.com/calendarandresults/?year=2010&region=&state=

If I select 2009, it does not work:

http://www.adodarts.com/calendarandresults/?year=2009&region=&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>

ded · 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?

Sign In

Website Not Appearing on Certain onClick

Recommended Posts

ded

Link to comment

Share on other sites

ded

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information