gistfile1.php

<?php

							$query = $db->query("SELECT * FROM `schools`", false)->execute();

							echo "<label for=\"username\">Home School:</label>";
							echo "<select name=\"homeSchool\" class=\"addGameField\">";
						    if ($db->getTotalRows($query)) {
						        while ($result = $db->fetch($query)) {
										echo "<option value=".$result['schoolID'].">".$result['schoolName']."</option>";
						 		}
						 		echo "</select>";
						    }

						    echo "<label for=\"username\">Away School:</label>";
							echo "<select name=\"awaySchool\" class=\"addGameField\">";
						    if ($db->getTotalRows($query)) {
						        while ($result = $db->fetch($query)) {
										echo "<option value=".$result['schoolID'].">".$result['schoolName']."</option>";
						 		}
						 		echo "</select>";
						    }

						    ?>