fetch_assoc()) { $table_data = ""; $all_stock_res = $db->query( "stock", "SELECT * FROM stock WHERE stock_type_id = '{$stock_list['record_id']}'" ); if ($all_stock_res->num_rows > 0) { while ($stock = $all_stock_res->fetch_assoc()) { $stock_data = $db->query( "stock", "SELECT * FROM stock WHERE stock_no = '{$stock['stock_no']}'" )->fetch_assoc(); $supplier = $db->query( "suppliers", "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'" )->fetch_assoc(); $stock_trans = $db->query( "stock_trans", "SELECT * FROM stock_trans WHERE stock_no = '{$stock['stock_no']}'" )->fetch_assoc(); if ($stock_data['stock_type_id'] == '1') { $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']}"; if ($stock_data['vehicle_type'] == 'ALL') { $table_data .= "ALL"; } else if ($stock_data['vehicle_type'] == 'T') { $table_data .= "TRUCK"; } else if ($stock_data['vehicle_type'] == 'D') { $table_data .= "DONKIE"; } else if ($stock_data['vehicle_type'] == 'C') { $table_data .= "COMP"; } else if ($stock_data['vehicle_type'] == 'CT') { $table_data .= "COMP TRUCK"; } else if ($stock_data['vehicle_type'] == 'OTHER') { $table_data .= "OTHER"; } else { $table_data .= "{$stock_data['vehicle_type']}"; } $table_data .= " {$supplier['name']} {$stock_trans['quantity']} {$stock_data['date_time']} "; } else if ($stock_data['stock_type_id'] == '2' || $stock_data['stock_type_id'] == '5') { $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']} {$stock_data['type']} {$stock_data['size']} {$supplier['name']} {$stock_trans['quantity']} {$stock_data['date_time']} "; } else if ($stock_data['stock_type_id'] == '3') { $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']} {$stock_data['pump_code']} {$supplier['name']} {$stock_trans['quantity']} {$stock_data['date_time']} "; } else if ($stock_data['stock_type_id'] == '4') { $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']} {$stock_data['serial_number']} {$supplier['name']} {$stock_trans['quantity']} {$stock_data['date_time']} "; } else { $table_data .= " {$stock_data['stock_no']} {$stock_data['item_name']} {$stock_list['name']} {$supplier['name']} {$stock_trans['quantity']} {$stock_data['date_time']} "; } } } else { $table_data = " NO STOCK FOUND "; } ?>

STOCK

STOCK NO	ITEM NAME	VEHICLE TYPE	SUPPLIER	QUANTITY	DATE

STOCK NO	ITEM NAME	TYPE	SIZE	SUPPLIER	QUANTITY	DATE

STOCK NO	ITEM NAME	PUMP CODE	SUPPLIER	QUANTITY	DATE

STOCK NO	ITEM NAME	SERIAL NUMBER	SUPPLIER	QUANTITY	DATE

STOCK NO	ITEM NAME	STOCK TYPE	SUPPLIER	QUANTITY	DATE