Working Material

SELECT *, SUM(order_qty) AS Torderqty, SUM(send_qty) AS Tsend_qty   FROM purchase_invoice_details WHERE order_qty > send_qty GROUP BY inv_id

<label><input type="checkbox" name="sample" class="selectall"/> Select all</label> <div id="checkboxlist">     <label> <input type="text" name="txt1" value="zandu"></label><br/>     <label><input type="checkbox" name="sample[]"/>checkbox1</label><br/>     <label><input type="checkbox" name="sample[]"/>checkbox2</label><br />     <label><input type="checkbox" name="sample[]"/>checkbox3</label><br />     <label><input type="checkbox" name="sample[]"/>checkbox4</label><br />     </div> $('.selectall').click(function() {     if ($(this).is(':checked')) {         $('input:checkbox').attr('checked', true);     } else {         $('input:ch