Accueil Stats de ventes clients

table"; $resul_test = mysql_query($query_test, $client->link); while($row_test = mysql_fetch_array($resul_test)){ $commande = new Commande(); $query_testa = "select * from $commande->table WHERE client='".$row_test[0]."' AND (statut='2' OR statut='3' OR statut='4')"; $resul_testa = mysql_query($query_testa, $commande->link); while($row_testa = mysql_fetch_array($resul_testa)){ $venteprod = new Venteprod(); $cpta += 1; $query_testb = "select * from $venteprod->table where commande='".$row_testa[0]."'"; $resul_testb = mysql_query($query_testb, $venteprod->link); while($row_testb = mysql_fetch_array($resul_testb)){ $cptb += $row_testb[6]; } } if($cpta >=1){ $refer[] = $row_test[1].",".$row_test[2].",".$cpta.",".$cptb; } $cpta=''; $cptb=''; } $annee = substr($row_test->date, 0, 4); /* $query_test = "select * from $commande->table where statut>=2 order by date desc limit 0,1"; $resul_test = mysql_query($query_test, $commande->link); $row_test = mysql_fetch_object($resul_test); $anneefin = substr($row_test->date, 0, 4); */ ?>
Nom Prénom Nb C.A €