Bonjouuuuuurrrr à tous ( et à toutes) !

Je rencontre le problème suivant, lors de l'insertion dans ma base, j'ai des champs qui s'iverse, en l'occurence:

"model_year "se retrouve dans le champ "description"
"price "se retrouve dans le champ "frais"
"make "se retrouve dans le champ "model"
"price "se retrouve dans le champ "frais"

etc etc etc....., tous les autres champs sont bien, pourtant j'ai mis la requete dans l'ordre de ma table, je ne comprends pas !

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
 $fichier='test.csv';
 $fp = fopen("$fichier", "r"); 
 
while (!feof($fp)) 
 { 
$ligne = fgets($fp,4096);
 
 /* ----------------------------------------- */
$liste = explode( ";",$ligne);
 /* ----------------------------------------- */ 
$id = $liste[0]; 
$make = $liste[1];
$model = $liste[2];
$exterior = $liste[3]; 
$description= $liste[4];
$model_year= $liste[5];
$mileage= $liste[6];
$frais= $liste[7];
$price= $price[8];
$userid = "1";
$location  = "1";
$user_type = "2";
$added = "1254171901";
$updated = "1254228171";
$expire = "0";
$user_expire = "0";
$viewed = "64";
$images = "0";
$hide = "0";
$featured = "0";
$status = "1";
$pending = "";
$stock = "";
$vin = "";
$cond = "Occasion";
$gen = "VP";
$carross = "CI";
$category = "";
$category2 = "";
$mileage_alt = "";
$sale = "";
$price_alt = "";
$interior = "";
$doors = "";
$fuel = "GO";
$drive = "";
$engine = "";
$trans = "";
$top_speed = "";
$horsepower = "";
$torque = "";
$towing = "";
$features = "";
$tagline = "";
$link_url = "";
$link_text = "";
$ebay_url = "";
$nom_acheteur = "";
$adresse_acheteur = "";
$cp_acheteur = "";
$ville_acheteur = "";
$w_garage = "";
$j_immat = "";
$m_immat = "";
$a_immat  = "";
 /* ----------------------------------------- */ 
$query = "INSERT INTO listings (userid,location,user_type,added,updated,expire,user_expire,viewed,images,hide,featured,status,pending,stock,vin,model_year,make,model,cond,gen,carross,category,category2,mileage,mileage_alt,price,sale,price_alt,exterior,interior,doors,fuel,drive,engine,trans,top_speed,horsepower,torque,towing,features,description,tagline,link_url,link_text,ebay_url,nom_acheteur,adresse_acheteur,cp_acheteur,ville_acheteur,w_garage,j_immat,m_immat,a_immat,frais)
VALUES('$userid','$location','$user_type','$added','$updated','$expire','$user_expire','$viewed','$images','$hide','$featured','$status','$pending','$stock','$vin','$model_year','$make','$model','$cond','$gen','$carross','$category','$category2','$mileage','$mileage_alt','$price','$sale','$price_alt','$exterior','$interior','$doors','$fuel','$drive','$engine','$trans','$top_speed','$horsepower','$torque','$towing','$features','$description','$tagline','$link_url','$link_text','$ebay_url','$nom_acheteur','$adresse_acheteur','$cp_acheteur','$ville_acheteur','$w_garage','$j_immat','$m_immat','$a_immat','$frais')";
 
$result= MYSQL_QUERY($query);
if(mysql_error())
 {
 print "Erreur !!!!!!!!!!".mysql_error();
 print "<br>Importation arrete.";
 exit();
 } 
 else /* Tout va bien */
 print "$id $make $model $exterior $description $model_year $mileage $frais $price <br>";
 } 
 
 echo "<br>Importation terminée !."; 
 
 /* Fermeture */ 
 fclose($fp); 
 MYSQL_CLOSE()
 ?>
Help Me please !!!