Use order with MEDOO

Question

I'm trying to use order by, I want to use this select:

Select * from tarea where cod_tarea = $row order by estado;

$tarea_data = $database->select("tarea","*",['cod_tarea' => $row], ["ORDER" => "estado"]);
$tarea_data = $database->select("tarea","*",['cod_tarea' => $row, "ORDER" => "estado"]);

But doesn't work

Answer 1

According to an example in the docs, you can do it like this:

$tarea_data = $database->select(
    "tarea",
    "*",
    [
        'cod_tarea' => $row, 
        "ORDER" => [
            "estado" => "ASC",
        ]        
    ]
);

Note that you should use DESC for descending in case you want a descending order of items. I am assuming you meant ascending here.