if ($gc == "YES") {
echo "<dd>Grand Champion</dd>";
}
}
if ($captions != NULL && $captions != "") {
$captions = "(" . $captions . ")";
} else {
$captions = "";
}
if ($class != "Exb") {
if ($class == "Finals" || $class == "SemiFinals") {
$display = "in {$class} {$captions}";
} else {
$display = "in Class {$class} {$type} {$captions}";
}
echo "<dd>" . getNumberExtension($place) . " Place {$display}</dd>";
}
}
echo "</dl></td><td>{$scoreslink}</td></tr></table>";
}
function getNumberExtension($place)
{
$returnstring = "";
if ($place == 1) {
$returnstring = $place . "st";
} else {
if ($place == 2) {
$returnstring = $place . "nd";
} else {
if ($place == 3) {
$returnstring = $place . "rd";
$query = "SELECT * FROM BandShows WHERE BandID = {$bandid} AND Year = {$year}";
$result = mysql_query($query, $connect);
$row = mysql_fetch_array($result);
echo "<tr><td><b>Show Title: </b></td><td>" . $row['Title'] . "</td></tr>";
echo "<tr><td colspan='2' align='center'><u><b>Scores</b></u></td></tr>";
$query = "SELECT Scores.FestivalID, Name, Scores.Class, Type, ClassPlace, Score \r\n\t\t\t\tFROM Scores, Festivals, ClassOrder \r\n\t\t\t\tWHERE Scores.FestivalID = Festivals.FestivalID \r\n\t\t\t\tAND Scores.Class = ClassOrder.Class\r\n\t\t\t\tAND FestivalYear = {$year} \r\n\t\t\t\tAND BandID = {$bandid} \r\n\t\t\t\tAND Type = 'Field'\r\n\t\t\t\tORDER BY Date, Type DESC, OrderNum ASC";
$result = mysql_query($query, $connect);
while ($row = mysql_fetch_array($result)) {
$name = $row['Name'];
$class = $row['Class'];
$type = $row['Type'];
$place = $row['ClassPlace'];
$score = $row['Score'];
$festid = $row['FestivalID'];
if ($score == NULL || $score == "") {
$score = getNumberExtension($place) . " Place";
}
echo "<tr><td colspan='2'><hr></td></tr><tr><td><b><a href='festivals_detail.php?FestivalID={$festid}'>{$name}</a> - {$class}:</b></td><td valign='bottom'><a href='scores_indiv.php?FestivalID={$festid}&archive-0'>{$score}</a></td></tr>";
}
echo "</table></td><br />";
}
}
echo "</tr></table>";
}
function getNumberExtension($place)
{
$returnstring = "";
if ($place == 1) {
$returnstring = $place . "st";
} else {
if ($place == 2) {
