select("*","inventory_items","","3171,3381",""); while($row=$db->fetch($res)) { $itemid=$row['id']; $invfound=''; $res_tmp_inv_itm=$db->select("*","sales_invoice_items","item='".$row['id']."'","","id ASC"); while($row_tmp_inv_itm=$db->fetch($res_tmp_inv_itm)) { $res_tmp_inv=$db->select("id,invoice_no","sales_invoices","id='".$row_tmp_inv_itm['invoice_id']."'","",""); $row_tmp_inv=$db->fetch($res_tmp_inv); $invfound.='--'.$row_tmp_inv['invoice_no'].''; } if($invfound) { echo $i.'-No-'.$itemid.'-ee-'.$invfound.'
'; } $i+=1; } ?>