work in progeress
select finance_carges.seller_id,finance_carges.rate, finance_carges.id, finance_carges.setpiece, finance_cat.type, finance_cat.name from finance_carges JOIN finance_cat on finance_carges.cat_id = finance_cat.id WHERE finance_cat.type = 'Fix Rate' and finance_carges.seller_id=''
select shipment_fm.id,shipment_fm.weight,shipment_fm.slip_no,dispatch_date as entry_date,DATE(shipment_fm.entrydate) as close_date,shipment_fm.code,shipment_fm.delivered,shipment_fm.status,shipment_fm.cust_id,shipment_fm.special_packaging,shipment_fm.pack_type,shipment_fm.destination,shipment_fm.frwd_company_id ,shipment_fm.booking_id ,shipment_fm.super_id ,shipment_fm.no_of_boxes,shipment_fm.pieces from shipment_fm WHERE dispatch_date!='' and MONTH(dispatch_date)='' and YEAR(dispatch_date)=
Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in /var/www/html/fastcoo_v4/employees/surendra/files/invoice/fixrate/fixrate_invoice.php on line 259

Warning: Invalid argument supplied for foreach() in /var/www/html/fastcoo_v4/employees/surendra/files/invoice/fixrate/fixrate_invoice.php on line 88