Tournament Result Details

Tournament: ” . $row[‘tournament’] . “ ($” . $row[‘purse’] . “)
“;
echo “Start Date: ” . $row[‘sdate’] . ” thru ” . $row[‘edate’] . “
“;
echo “City/State/Region: ” . $row[‘city’] . “, ” . $row[‘state’] . ” (” . $row[‘region’] . “)
“;
if ($row[‘website’] != NULL)
{
echo “Association: ” . $row[‘association’] . “
“;
} else {
echo “Association: ” . $row[‘association’] . “
“;
}
echo “

“;
}

$query2 = “SELECT * FROM `tournamentresults` WHERE `tournamentid` = ‘$rrn’ ORDER BY `rrn`”;
$result2 = mysqli_query($dbh,$query2) or die(mysqli_error($dbh));
$eventhld = “default”;

echo “

“;

while($row2 = mysqli_fetch_array($result2))
{
if ($eventhld != $row2[‘event’])
{
echo “

“;
}
echo “

“;
$eventhld = $row2[‘event’];
}
echo “


” . $row2[‘event’] . ” – ” . $row2[‘entries’] . ” entries
“;
echo “

Placed Player Name Affiliation Pts
“;
echo $row2[‘placed’];
echo “
“;
echo $row2[‘playername’];
echo “
“;
echo $row2[‘affiliation’];
echo “
“;
echo $row2[‘nationalpoints’];
echo “

“;
?>