0

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

Barmar
  • 741,623
  • 53
  • 500
  • 612

0 Answers0