How do to no sort by the first col by default when no specify order in the url ?

[mapoub]

hello @mevdschee

When i call php-crud-api "http://XXXXXXXXXX/records/test", i constate that php-crud-api sort data by the first col.
I don't want sort.
How do to no sort by the first col by default ?
if this already exist, it"s possible to add in the readme ?

Example :
1/ I have for example a table "test" with this data :
val ( is the col)
3
1
2

2/ "select * from test" in mysql
result is
val
3
1
2

3/ call php-crud-api -> http://XXXXXXXXXX/records/test
result is
{
"records": [
{"val": 1},
{"val": 2},
{"val": 3}]
}
Datas are sorted !!!!

How do to no sort by the first col by default . I would like to have this :
{"records": [
{"val": 3},
{"val": 1},
{"val": 2}]}

Thx for your answer ;-)

[mevdschee]

Technically records in a database have no order (I know, I know...).

See: https://dba.stackexchange.com/questions/186885/is-there-a-default-select-order

You can sort using the "order=" GET parameter:

https://github.com/mevdschee/php-crud-api?tab=readme-ov-file#ordering

GET /records/test?order=val,desc

Does that help?