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());
} |
Partager