select("*","sales_invoices","added_date BETWEEN '2018-06-20' AND '2018-08-30'","",""); while($rowsys=$db->fetch($ressys)) { $countdo=$db->countRow("inventory_do","invoice_id='".$rowsys['id']."'",""); if($countdo) { $resdo=$db->select("*","inventory_do","invoice_id='".$rowsys['id']."'","",""); while($rowdo=$db->fetch($resdo)) { $resinvi=$db->select("*","sales_invoice_items","invoice_id='".$rowsys['id']."'","",""); while($rowinvi=$db->fetch($resinvi)) { $countdoitem=$db->countRow("inventory_do_items","do_id='".$rowdo['id']."' AND item='".$rowinvi['item']."'",""); if(!$countdoitem){ echo $rowsys['id'].' '.$rowinvi['item'].' Not Found
'; } } } } else { echo 'No'.$rowsys['id'].' '.$rowsys['invoice_no'].'
'; } } ?>