= '{$current_day}' "; $result = $pdo->query($sql); $rowset = $result->fetchAll(PDO::FETCH_ASSOC); $result->closeCursor(); $run_array = array(); foreach( $rowset as $row_info ) { $run_id = $row_info["RUN_ID"]; $sql_txt = " SELECT count(*) as err_num FROM run_{$run_id} WHERE SEAT_STATUS=1 "; $result = $pdo->query($sql_txt); $rowset_result = $result->fetchAll(PDO::FETCH_ASSOC); $result->closeCursor(); if( $rowset_result[0]["err_num"] > 0 ) { echo "RUN_".$run_id."
"; } } echo "success"; exit();