Bonjour je voulais savoir comment faire pour optimiser ma requette ou la raccourcir si quelqu'un peu m'éclairer ou me dirigé ce serai gentille

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
$total_commandes = "";
	//client payE 
	//adwords
	$query_ad = "SELECT   COUNT(DISTINCT customers_id) AS count_adw FROM customers WHERE  (customers_client='1' or customers_emv='1' or customers_seance ='1' or customers_emv='1' )and customers_from='adwords'  ";
	$result_ad = mysql_query($query_ad); 
	//rien
	$query ="SELECT   COUNT(DISTINCT customers_id) AS count_adw FROM customers WHERE  (customers_client='1' or customers_emv='1' or customers_seance ='1' or customers_emv='1' )and customers_from=''   ";
	$result = mysql_query($query);
	//autre
	$query_oth ="SELECT   COUNT(DISTINCT customers_id) AS count_adw FROM customers WHERE  (customers_client='1' or customers_emv='1' or customers_seance ='1' or customers_emv='1' )and customers_from!='adwords' and  customers_from!='' ";
	$result_oth = mysql_query($query_oth);
	//total
	$query_tt = "SELECT   COUNT(DISTINCT customers_id) AS count_adw FROM customers WHERE  (customers_client='1' or customers_emv='1' or customers_seance ='1' or customers_emv='1' )";
	$result_tt = mysql_query($query_tt);
je veu sortire plusieur info dans un tableau merci