Recuperer les nom de colonnes dans un array
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:
$tab = array("Nice","Cagnes","Vence","Sophia","Cannes");
J'essai avec differentes requetes mais aucine ne me renvoi un tableau équivalent:
Code:
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 :
Citation:
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.
