“;
echo $pname;
echo “ Individual results for ” . $playername;
echo $year;
echo “ ADO Affiliation: “;
echo $affiliation;
echo “ |
| Tournament |
Event |
Entries |
Placed |
Points |
“;
?>
= ‘2012-01-01’ AND `date` <= '2012-12-31' ORDER BY `date`";
$result6 = mysqli_query($dbh,$query6) or die(mysqli_error($dbh1));
while($row6 = mysqli_fetch_array($result6))
{
$region = $row6['region'];
$date = $row6['date'];
$id = $row6['tournamentid'];
$event = $row6['event'];
$entries = $row6['entries'];
$placed = $row6['placed'];
$points = $row6['nationalpoints'];
$totalpoints = $totalpoints + $points;
$totalevents = $totalevents + 1;
mysqli_select_db ($dbh,"adodarts_TournamentCalendar");
$queryu = "SELECT * FROM `ADOSanctionedTournaments` WHERE `rrn` = '$id'";
$resultu = mysqli_query($dbh,$queryu) or die(mysqli_error($dbh));
$tournament = '';
while($rowu = mysqli_fetch_array($resultu))
{
$tournament = $rowu['tournament'];
}
if ($tournament == '')
{
$tournament = $id;
}
echo "
“;
echo ““;
echo $tournament . ” ” . $date;
echo ““;
echo “ |
“;
echo ““;
echo $event;
echo ““;
echo “ |
“;
echo ““;
echo $entries;
echo ““;
echo “ |
“;
echo ““;
echo $placed;
echo ““;
echo “ |
“;
echo ““;
echo $points;
echo ““;
echo “ |
“;
}
echo “
Total Information for “;
echo $pname;
echo “ |
“;
echo $totalevents;
echo ” events |
|
|
“;
echo $totalpoints;
echo “ |
“;
?>