echo "<table>\n" ;
echo "  <thead>\n" ;
echo "  <tr>\n" ;
echo "    <td>abv</td>\n" ;
echo "    <td>city</td>\n" ;
echo "    <td>country</td>\n" ;
echo "    <td>noaa</td>\n" ;
echo "  </tr>\n" ;
echo "  </thead>\n" ;
echo "  <tbody>\n" ;
$query = "SELECT * FROM `airportcodes`" ;
$result = mysql_query($query,$link) ;
while ($row = mysql_fetch_array($result)) {
    echo "  <tr>\n" ;
    echo "    <td>".$row['abv']."</td>\n" ;
    echo "    <td>".$row['city']."</td>\n" ;
    echo "    <td>".$row['country']."</td>\n" ;
    echo "    <td>".$row['noaa']."</td>\n" ;
    echo "  </tr>\n" ;
    }
echo "  </tbody>\n" ;
echo "</table>\n" ;