BDO Results

2000-01-01″;
$query = “SELECT * FROM `ADOSanctionedTournaments` WHERE `results` = ‘Y’ and `bdoranked` = ‘on’ ORDER BY `sdate` desc”;
$result = mysqli_query($dbh,$query) or die(mysqli_error($dbh));
?>

“;
}
echo “

“;
$alphamonthhold = $alphamonth;
}
echo “

“;
echo ‘

‘ . $alphamonth . ‘ ‘ . $yearSort . ‘

‘;
echo “

“;
echo substr($row[‘sdate’],8,2);
if(substr($row[‘sdate’],8,2) != substr($row[‘edate’],8,2))
{
echo “-” . substr($row[‘edate’],8,2) . ” “;
}
echo “
“;
echo ““;
echo $row[‘tournament’];
echo “
“;
if ($row[‘cancelled’] == “on”)
{
echo “**CANCELLED**“;
}
echo “” . $row[rrn] . ““;
echo “
“;
echo “$” . number_format($row[‘purse’]);
echo “
“;
echo $row[‘state’];
echo “
“;
$query2 = “SELECT * FROM `tournamentresults` WHERE `tournamentid` = ‘$rrn’ ORDER BY `rrn`”;
$result2 = mysqli_query($dbh,$query2) or die(mysqli_error($dbh));
if($row2 = mysqli_fetch_array($result2))
{
echo ” results“;
}
echo “

“;
?>