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
je veu sortire plusieur info dans un tableau merci
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);
Partager