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) {