Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $currentMonth = date("Y-m");
- $sql0 = "SELECT id FROM invoices WHERE due_date LIKE '$currentMonth-%' ";
- $result0 = mysqli_query($conn, $sql0);
- while($r = mysqli_fetch_array($result0)) {
- $id = $r["id"];
- echo "</br></br>" . $r['id'] . "</br></br>";
- $rows = explode( ' ', $r["id"]);
- foreach($rows as $id){
- $result = mysqli_query($conn, "SELECT total FROM invoice_items WHERE invoice_id = '$id' ");
- while($row = mysqli_fetch_assoc($result)){
- echo $row['total'];
- $sumArray[] = $row['total'];
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement