$res2 = mysql_query("SELECT * FROM Pilots WHERE Licencia = '$usuario'");
$loc = mysql_result($res2, 0, 'LOC');

$res = "SELECT * FROM flights WHERE acft in(SELECT C172 FROM Pilots WHERE Licencia = '$id')";
	$res = $res ." UNION ";
$res = $res ."SELECT * FROM flights WHERE acft in(SELECT PA28 FROM Pilots WHERE Licencia = '$id')";

$res2 = mysql_query("SELECT * FROM Bookings WHERE Licencia = '$usuario'");
$filas2 = mysql_num_rows($res2);


$result = mysql_query($res);

	
if($filas2 == 0){
		?>
		<table cellpadding="2" cellspacing="0" style="text-align: center; width: 100%;">
		<tr style="background-color: #000046; font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: white; text-align: center;"><td></td><td>Num. Vuelo</td><td>Modelo</td><td>Salida</td><td>Llegada</td><td>EET</td><td>Precio</td><td>Reservar</td></tr>
		<?
		while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
		{
			$id = $row['id'];
			$icao = $row['acft'];
			$sal = $row['departure'];
			$lleg = $row['destination'];
			$precio = $row['precio'];
			$codigo = "<a href=\"reservar-aeronave.php?vuelo=$id&loc=$loc&icao=$icao\"><img src=\"http://airiberova.x10.mx/vasystem/images/tick.png\" alt=\"si\" /></a>";
			$res3 = mysql_query("SELECT Matricula FROM Bookings WHERE Vuelo = '$id'");
			for($j = 0; $j < mysql_num_rows($res3); $j++)
			{
				$mat = mysql_result($res3, $j);
				$res4 = mysql_query("SELECT icao FROM aeronaves WHERE matricula = '$mat'");
				$icaores = mysql_result($res4, 0);
				$res2 = mysql_query("SELECT tipo FROM flota WHERE icao = '$icaores'");
				$tipo = mysql_result($res2, 0);
				if($icaores == $icao) $codigo = '<img src="http://airiberova.x10.mx/vasystem/images/no.png" alt="no" />';
			}		
			$eet = mysql_result($res, $i, 'eet');
			$color = $i % 2 == 0 ? $color = 'white' : '#CCC';
			
			echo "<tr style=\"text-align: center; font-size: 10px; font-family: Arial, Helvetica, sans-serif; background-color: $color;\"><td><img src='http://airiberova.x10.mx/vasystem/images/vuelo.gif'></td><td>$id</td><td>$icao</td><td>$sal</td><td>$lleg</td><td>$eet</td><td>$precio &euro;</td><td>$codigo</td></tr>\n";
		}
		echo '</table>';
	}

$var = mysql_result($result, $i, 'departure');