Player Results

[insert_php]
ini_set(“display_errors”, 1);

session_name(‘nbdca’);
session_start();

define(“SQLServer”, “markrozum.com”);

define(“SQLUser”, “mrozum_nbdca”);
define(“SQLPassword”, “81Delorean”);
define(“DBName”, “mrozum_nbdca”);

$DB = mysql_connect(SQLServer, SQLUser, SQLPassword);
mysql_select_db(DBName,$DB);

$playerID = $_GET[‘playerID’];

$SQL = “Select * from Events where md5(ID) = ‘$eventID’ AND Active = 1”;
$rsEvent = mysql_query($SQL, $DB);
$event = mysql_fetch_assoc($rsEvent);

$SQL = “Select * from Divisions where Abbreviation in (‘” . str_replace(“,”, “‘,'”, $event[‘Divisions’]) .”‘) Order by ID”;
$rsDivisions = mysql_query($SQL, $DB);

echo “

” . $event[‘Name’] . ” ” . date(“F d, Y”, strtotime($event[“StartDate”])) . ‘ – ‘ . date(“F d, Y”, strtotime($event[“EndDate”])) . “

“;

while ($divisions = mysql_fetch_assoc($rsDivisions)) {
$SQL = “Select S.*, concat(M1.FirstName, ‘ ‘, M1.LastName) as Handler,
D.DogName as Dog,
concat(M2.FirstName, ‘ ‘, M2.LastName) as Partner
from Members M1, Members M3, Dogs D, Scores S
left outer join Members M2 on M2.TH_ID = S.PartnerID
where md5(S.EventID) = ‘$eventID’ AND S.Division = ‘” . $divisions[‘Abbreviation’] . “‘ AND S.HandlerID = M1.TH_ID AND S.DogID = D.THCC_ID AND D.TH_ID = M3.TH_ID order by S.EventMo, S.ScorePoints desc, S.QualPoints desc, S.ChampionPoints desc, S.ID”;
$rsScores = mysql_query($SQL , $DB);
echo ”

” . $divisions[‘Division’] . ““;

echo “

“;
if ($divisions[‘Abbreviation’] == ‘DBLSF’ || $divisions[‘Abbreviation’] == ‘DBLSP’) {
echo ”

“;
}
echo ”

“;
while ($scores = mysql_fetch_assoc($rsScores)) {
echo “

“;
if ($divisions[‘Abbreviation’] == ‘DBLSF’ || $divisions[‘Abbreviation’] == ‘DBLSP’) {
echo ”

“;
}
echo ”

“;
}
echo ”

“;
} [/insert_php]