Pardonnez mon ignorance mais je rame un peu sur le formatage d'un array en vue d'une sortie CSV.

Comment pourrais-je obtenir une sortie CSV de ce type cad sans guillemets :
Ref commande;ID client;Nom;Prenom;Adresse;Adresse 2;Ville;Code postal;Pays;Email;Telephone;Urgent;Remarques;Code article;Quantite;Date livraison
FFATNOMMJ;My Company;DOE;John;16, Main street;2nd floor;Miami;33133;US;pub@prestashop.com;0102030405;;;demo_1;1;

Je ne sais pas trop manipuler les array mais j'ai essayé ceci sans succès :
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
 
$export = $connexion->query("
		  SELECT 
		  'Ref commande', 
		  'ID client', 
		  'Nom', 
		  'Prenom', 
		  'Adresse', 
		  'Adresse 2', 
		  'Ville', 
		  'Code postal', 
		  'Pays', 
		  'Email',
		  'Telephone',
		  'Urgent',
		  'Remarques',
		  'Code article',
		  'Quantite',
		  'Date livraison'
 
 
			UNION ALL
 
 
 
		  SELECT 
		  ps_orders.reference, 
		  ps_address.company, 
		  ps_address.lastname, 
		  ps_address.firstname, 
		  ps_address.address1, 
		  ps_address.address2, 
		  ps_address.city, 
		  ps_address.postcode,
		  ps_country.iso_code,
		  ps_customer.email,
		  ps_address.phone,
		  '',
		  '',
		  ps_product.reference,
		  ps_cart_product.quantity,
		  ''  
 
 
 FROM ps_cart_product 
 LEFT JOIN ps_product ON (ps_cart_product.id_product = ps_product.id_product) 
 LEFT JOIN ps_orders ON (ps_orders.id_cart = ps_cart_product.id_cart) 
 LEFT JOIN ps_customer ON (ps_orders.id_customer = ps_customer.id_customer) 
 LEFT JOIN ps_cart ON (ps_cart.id_cart = ps_cart_product.id_cart) 
 LEFT JOIN ps_address ON (ps_cart.id_address_delivery = ps_address.id_address) 
 LEFT JOIN ps_country ON (ps_country.id_country = ps_address.id_country) 
 
 GROUP BY
 		  ps_orders.reference, 
		  ps_address.company, 
		  ps_address.lastname, 
		  ps_address.firstname, 
		  ps_address.address1, 
		  ps_address.address2, 
		  ps_address.city, 
		  ps_address.postcode,
		  ps_country.iso_code,
		  ps_customer.email,
		  ps_address.phone,
		  ps_product.reference,
		  ps_cart_product.quantity
 
 
 ");
$list = array();
while ($data = $export->fetch()) {
$list[] = $data['Ref commande'].';'.$data['ID client'].';'.$data['Nom'].';'.$data['Prenom'].';'.$data['Adresse'].';'.$data['Adresse 2'].';'.$data['Ville'].';'.$data['Code postal'].';'.$data['Pays'].';'.$data['Email'].';'.$data['Telephone'].';'.$data['Urgent'].';'.$data['Remarques'].';'.$data['Code article'].';'.$data['Quantite'].';'.$data['Date livraison'];
}
 
$file = fopen("prestashop.csv","w");
 
foreach ($list as $line)
  {
  fputcsv($file,explode(',',$line));
  }
 
fclose($file); 
  }
}
Ce qui donne :
"Ref commande;ID client;Nom;Prenom;Adresse;Adresse 2;Ville;Code postal;Pays;Email;Telephone;Urgent;Remarques;Code article;Quantite;Date livraison"
"FFATNOMMJ;My Company;DOE;John;16"," Main street;2nd floor;Miami;33133;US;pub@prestashop.com;0102030405;;;demo_1;1;"

Les guillemets m'embêtent pour la sortie CSV excel.

Pouvez-vous svp m'aider sur ce coup