search

oscarotero / simple-crud

PHP library to provide magic CRUD in MySQL/Sqlite databases with zero configuration
MIT License
242 stars 58 forks source link

Order by sorting stop working #56

Closed darkvovich closed 5 months ago

darkvovich commented 5 months ago

This select working many months $db->events->select()->whereEquals(['sprId' => $spreadsheetId, "created >= '".date('Y-m-d H:i:s', strtotime('-3 days'))."'"])->orderBy('created DESC')->get(); but now stop working

Seems that SCRIPT not see fresh rows. bcs if set strtotime('-5 days') its working, but not fresh

darkvovich commented 5 months ago

$eventsList = $db->events->select()->whereEquals(['sprId' => $spreadsheetId])->orderBy('created DESC')->limit(10)->get(); return last row at 2024-06-09 11:03:27 image

but really last row is 2024-06-14