fetch_assoc()) { $table_data = ""; // ✅ reset per stock type $all_stock_res = $db->query( "stock_control", "SELECT * FROM stock_control WHERE stock_type = '{$stock_list['record_id']}'" ); if ($all_stock_res->num_rows > 0) { while ($stock = $all_stock_res->fetch_assoc()) { $stock_data_res = $db->query( "stock", "SELECT * FROM stock WHERE stock_no = '{$stock['stock_no']}'" ); $stock_data = $stock_data_res->fetch_assoc(); $supplier_res = $db->query( "suppliers", "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'" ); $supplier = $supplier_res->fetch_assoc(); $stock_trans_res = $db->query( "stock_trans", "SELECT * FROM stock_trans WHERE stock_no = '{$stock['stock_no']}'" ); $stock_trans = $stock_trans_res->fetch_assoc(); // echo "{$stock['record_id']}"; $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']} {$stock_list['name']} {$supplier['name']} {$stock_trans['quantity']} "; } } else { $table_data = " NO STOCK FOUND "; } ?>

STOCK

STOCK NO	ITEM NAME	STOCK TYPE	SUPPLIER	QUANTITY