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
| $sql2 = "SELECT SUM( qntit ) AS SOMME, d.nam, a.date AS dat
FROM lob a, load_qnt b, product d, distrebutor e
WHERE a.id_load = b.id_load
AND b.id_pro = d.id_pro
AND e.id_dis = a.id_dis
AND e.id_dis= 3
AND MONTH(a.date) = MONTH(CURRENT_DATE())
AND YEAR(a.date) = YEAR(CURRENT_DATE())
GROUP BY d.id_pro;";
$sql2 .= "SELECT a.quantite AS SOM
FROM order_quantite a, order b
WHERE a.id_order = b.id_order
AND MONTH(b.datee) = MONTH(CURRENT_DATE())
AND YEAR(b.datee) = YEAR(CURRENT_DATE())
GROUP BY a.id_pro";
if ($mysqli->multi_query($sql2)) {
do {
/* store first result set */
if ($result = $mysqli->store_result()) {
while ($row = $result->fetch_row()) {
printf("%s\n", $row[0]);
}
$result->close();
}
/* Affichage d'une séparation */
if ($mysqli->more_results()) {
printf("-----------------\n");
}
} while ($mysqli->next_result());
} |
