<?php

	$host="localhost:3306";
	$user="root";
	$password="";
	$dbname="transport_aerien";
	$connect = @mysql_connect($host,$user,$password);
	$db_select = mysql_select_db ($dbname, $connect);
	$reponse = @mysql_query($connect);
	$N = @mysql_num_fields($reponse);


	if ( $connect == true)
		echo"connextion etablie<br><br>";
	else	echo "connextion non établie<br><br>";

	$db_select = @mysql_select_db($dbname,$connect);
	if ( $db_select == true)
		echo" db select ok<br><br>";
	else	echo "db_select<br><br>";

	$reponse = @mysql_query('SELECT PLNUM,PLNOM FROM PILOTE');
		if ( $reponse == false)
		echo"Erreur mysql_query";
	else	echo "OK mysql_query<br><br>";

	$N = @mysql_num_fields($reponse);
	echo "$N colonnes<br><br>";

	for ($i=0; $i<$N;$i++)
	{
		$col0 = @mysql_field_name($reponse, $i);
		echo "colonne n°$i = $col0 <br><br>";
	}

	echo "<table border = 1><tr>";
    for($i= 0;$i<$N; $i++)		echo "<th>".mysql_field_name($reponse, $i)."</th>"; //
	echo "</tr>";

	while (  ( $ligne = mysql_fetch_array($reponse))  !=  false  )
	{
		echo "<tr>";
		for($i=0; $i<$N ; $i++)		echo "<td> $ligne[$i]</td>";
		echo "</tr>";
	}
	echo "</table>";


?>