<?php
	ini_set('display_errors', 1);
	ini_set('display_startup_errors', 1);
	error_reporting(E_ALL);

	require ('../../../core/controller/Database_admin.php');
    $db = Database::connectPDO();
	
	$line = $_POST['line'];
	
	$statement_1 = $db->query("SELECT * FROM strategic_action WHERE line_action = '$line' ORDER BY line_action");
	$res = $statement_1->fetchAll();

	$html= "<option value=''>- SELECCIONAR ACCIÓN -</option>";
	
	if(isset($res)){
		foreach ($res as $row){
			$html.= "<option value='".$row['name_action']."'>".$row['name_action']."</option>";
			
		}
	}
	echo $html;

	
?>


