How to write this query with medoo?
query="SELECT DISTINCT id FROM items WHERE name='Mag' AND var='Bl' ORDER BY atrow +0 ASC"
In the query results above, they are sorted according to the atrow values from the smallest to the largest
Can anyone help?
$item= $database->select("items", "@id", [ "var[=]" => "Bl", "name[=]" => "Mag","ORDER" => [ " atrow" => "ASC" ] ]);
But
Every time I refresh, the order is messed up