2012 National Rankings

Last Updated: ” . $rowT[‘entered_date’] . ‘ EST‘;
}

$queryU = “SELECT * FROM `tournamentresults` ORDER BY `rrn` DESC Limit 0,1”;
$resultU = mysqli_query($dbh, $queryU) or die(mysqli_error($dbh));

if($region == “” && $event == “”)
{
$query = “SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` WHERE `gender` = ‘$gender’ and `affiliation` <> ‘ ‘ and substr(`date`, 1, 4) = ‘2012’ GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC”;
$result = mysqli_query($dbh, $query) or die(mysqli_error($dbh));
}
if($region != “” && $event == “”)
{
$query = “SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` WHERE `gender` = ‘$gender’ and `region` = ‘$region’ and `affiliation` <> ‘ ‘ and substr(`date`, 1, 4) = ‘2012’ GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC”;
$result = mysqli_query($dbh, $query) or die(mysqli_error($dbh));
}
if($region == “” && $event != “”)
{
$query = “SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` WHERE `gender` = ‘$gender’ and `event` = ‘$eventdescr’ and `affiliation` <> ‘ ‘ and substr(`date`, 1, 4) = ‘2012’ GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC”;
$result = mysqli_query($dbh, $query) or die(mysqli_error($dbh));
}
if($region != “” && $event != “”)
{
$query = “SELECT *, SUM(`nationalpoints`) FROM `tournamentresults` WHERE `gender` = ‘$gender’ and `event` = ‘$eventdescr’ and `region` = ‘$region’ and `affiliation` <> ‘ ‘ and substr(`date`, 1, 4) = ‘2012’ GROUP BY `playername` ORDER BY SUM(`nationalpoints`) DESC”;
$result = mysqli_query($dbh,$query) or die(mysqli_error($dbh));
}
?>

= ‘2012’)
{

$rank = $rank + 1;
if ($ptshold != $natpts)
{
$rankh = $rank;
}
$ptshold = $natpts;
echo ‘

‘;
$url = “” . $name . ““;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
}
}

$dbh2=mysqli_connect (“localhost”, “adodarts_website”, “4S07%J]g2K06”) or die (‘I cannot connect to the database because: ‘ . mysqli_error($dbh2));
mysqli_select_db ($dbh2, “adodarts_database1”);
$query2 = “SELECT * FROM `affiliations` WHERE `acronym` = ‘$affiliation'”;
$result2 = mysqli_query($dbh2,$query2) or die(mysqli_error($dbh2));
while($row = mysqli_fetch_array($result2))
{
$year = $row[‘year’];
//if($year >= ‘2012’)
if($year >= ‘2000’)
{
$rank = $rank + 1;
if ($ptshold != $natpts)
{
$rankh = $rank;
}
$ptshold = $natpts;
echo ‘

‘;
$url = “” . $name . ““;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
}
}
?>