'; } // // //Alle teams lijst maken // // if ($team == '') { //if display $sqlteam = "SELECT Team, Map, OfficialLink, Schedule FROM Display WHERE Type = 'Team' ORDER BY Team ASC"; $sqlsolo = "SELECT Team, Map, OfficialLink, Schedule FROM Display WHERE Type = 'Solo' ORDER BY Team ASC"; $resteam = mysql_query($sqlteam,$link); $ressolo = mysql_query($sqlsolo,$link); if ($resteam && mysql_num_rows($resteam) < 1) { header('HTTP/1.0 404 Not Found'); require ("404.php"); } elseif ($resteam && mysql_num_rows($resteam) >= 1) { $pageTitle = 'Display teams of the World | Roview.nl'; // define the page title $pageDescr = 'Blue Angels, Thunderbirds, Red Arrows, Patrouille de France, Patrouille Suisse'; echo '

'; echo '

Display teams of the world

Whether you call them stunt teams, aerobatic teams, aerial demonstration teams or display teams, they are the highlights of airshows around the world. Below you find an overview of military display teams.

Below you can find links to information about the teams including pictures as well as links to official sites and official schedules.

'; echo '

'; echo ''; while ($row = mysql_fetch_array($resteam)) { echo ''; } echo ''; while ($row = mysql_fetch_array($ressolo)) { echo ''; } echo ''; } } //if display //einde if team is niets //geen ifjes open else // // // van een team alle info plotten // // { // else team $sql = "SELECT * FROM Display WHERE Map = '" . $team . "'"; $res = mysql_query($sql,$link); if ($res && mysql_num_rows($res) < 1) { header('HTTP/1.0 404 Not Found'); require ("404.php"); } elseif ($res && mysql_num_rows($res) >= 1) { //elseif echo '

'; while ($row = mysql_fetch_array($res)) { //ifje3 $map = $row['Team']; if ($row['Logo'] == 'yes') { echo '

'; } echo '

'.$row['Team'].'

'; if($row['Official'] != '') { echo '

Official name: '.$row['Official'].'

'; } if($row['Active'] != '') { echo '

Active: '.$row['Active'].'

'; } if($row['Home'] != '') { echo '

Home base: '.$row['Home'].'

'; } if($row['Aircraft'] != '') { echo '

Aircraft

'.$row['Aircraft'].'

'; } if($row['History'] != '') { echo '

History

'.$row['History'].'

'; } if ($row['OfficialLink'] != '' || $row['WikiLink'] != '' || $row['Schedule'] != '') { echo '

Links

'; if($row['OfficialLink'] != '') { echo 'Official page'; } if($row['OfficialLink'] != '' && $row['WikiLink'] != '') { echo ' | '; } if($row['WikiLink'] != '') { echo 'Wikipedia page'; } if(($row['OfficialLink'] != '' || $row['WikiLink'] != '') && $row['Schedule'] != '') { echo ' | '; } if($row['Schedule'] != '') { echo 'Schedule'; } } $photo = ''.$row['Photo'].''; if ($photo != '') { echo '

Photos

'; } $pageTitle = ''.$row['Team'].' | Roview.nl'; // define the page title $pageDescr = ''.$row['Intro'].''; if (($photo != 0) && ($view == '')) { echo '

Full size

'; } elseif (($photo != 0) && ($view == 'view')) { echo '

Thumbnails

'; } if ( $photo != 0 ) { //ifje4 echo '

'; if ($view != 'view') //start thumbnails { $count = 0; for ($number = 1; $number <= $row['Photo']; $number += 1) { echo '

'; $count = $count + 1; if ($count == 4) { echo '
'; $count = 0; } } } //end thumbnails elseif ($view == 'view') //start full { echo '

'; for ($number = 1; $number <= $row['Photo']; $number += 1) { echo '

'; } echo '

'; } //end full echo '

'; $sql = "SELECT Team, Map FROM Display ORDER BY Team ASC"; $res = mysql_query($sql,$link); if ($res && mysql_num_rows($res) >= 1) { echo '

Display team overview
';
              $i = 0;
              while ($row = mysql_fetch_array($res))
                    {

                    echo ' ';
         
                    if ($map == $row[Team])
                    { echo ''.$row[Team].''; }
                    else
                    { echo ''.$row[Team].''; }
                    echo '
';

                    if ($i < mysql_num_rows($res)-1)
                    { echo ' - '; }
                    $i++;
                    }
                echo '

'; } } //ifje4 echo ''; echo '

'; $sqlprev = "SELECT Map, Team FROM Display WHERE Team < '$map' ORDER BY Team DESC LIMIT 1 "; $sqlnext = "SELECT Map, Team FROM Display WHERE Team > '$map' ORDER BY Team ASC LIMIT 1 "; $resprev = mysql_query($sqlprev,$link); if ($resprev && mysql_num_rows($resprev) >= 1) { while ($row = mysql_fetch_array($resprev)) { echo '

'; } } $resnext = mysql_query($sqlnext,$link); if ($resnext && mysql_num_rows($resnext) >= 1) { while ($row = mysql_fetch_array($resnext)) { echo '

'; } } } //ifje3 } //elseif } //else team ?>

Name	Official site	Schedule
'.$row['Team'].'	'; if ($row['OfficialLink'] != '') { echo ''; } echo '	'; if ($row['Schedule'] != '') { echo ' '; } echo'

'.$row['Team'].'	'; if ($row['OfficialLink'] != '') { echo ''; } echo '	'; if ($row['Schedule'] != '') { echo ' '; } echo'