J'essai deseperement de mettre dans un menu deroulant les titres des colonnes de ma table mais sans succes.

Si je crée un tableau, mes menus fonctionnent sans problème:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
$tab = array("Nice","Cagnes","Vence","Sophia","Cannes");
J'essai avec differentes requetes mais aucine ne me renvoi un tableau équivalent:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
$sql = "SHOW COLUMNS FROM `tarif`";
$result = mysql_query($sql,$db) or die("erreur de traitement de la requête: ".mysql_error());
$tab = mysql_fetch_row($result);
while ($tab = mysql_fetch_row($result) ) {
print_r($tab);
}
print_r renvoi :

Array ( [0] => aeroport de Nice [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Cagnes sur Mer [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => St Laurent du Var [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Villeneuve Loubet [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Nice [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Villefranche sur Mer [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Beaulieu sur Mer [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Antibes [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Vence [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Saint Paul de Vence [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => La Colle sur Loup [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Tourrettes sur Loup [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => St Jeannet [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Carros [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Sophia Antipolis [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Mougins [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Cannes [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Mandelieu [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Monaco [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Grasse [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Menton [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Fr�jus [1] => varchar(30) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Saint Tropez [1] => int(11) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Aix en Provence [1] => int(11) [2] => NO [3] => [4] => [5] => ) Array ( [0] => Marseille [1] => int(11) [2] => NO [3] => [4] => [5] => )
Est ce qu'il y a un moyen de recuperer simplement les titres des colonnes dans un array ou suis-je obligé de rajouter une ligne dans ma table reprenant les noms de colonnes ?

Merci d'avance.