query("stock_take_stock", "SELECT sto.description,st.amount_in_stock,st.amount_counted FROM `stock_take_stock` as st LEFT JOIN stock as sto on st.item_id = sto.record_id WHERE st.stock_take_id = '" . $_GET['record_id'] . "' ORDER BY st.record_id ASC"); while ($row = $res->fetch_assoc()) { header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=stock_take_" . $_GET['record_id'] . ".xls"); echo pack("CCC", 0x1F, 0x08, 0x08); echo ""; echo ""; while ($row = $res->fetch_assoc()) { echo ""; } echo "

Item Description	Amount in Stock	Amount Counted
" . $row['description'] . "	" . $row['amount_in_stock'] . "	" . $row['amount_counted'] . "

"; } echo "";