How to add order by id desc in this query?

$resultGetProducts = $dbh->query("SELECT * FROM " . env('DB_DATABASE') . ".allDBProducts ")->fetchAll(PDO::FETCH_ASSOC);

I tried something like this but it returns null

$resultGetProducts = $dbh->query("SELECT * FROM " . env('DB_DATABASE') . ".allDBProducts ORDER BY .id. DESC ")->fetchAll(PDO::FETCH_ASSOC);

Best Answer

Level 75

The query Builder chapter has examples of orderby.

Example from the documentation

$users = DB::table('users')
                ->orderBy('name', 'desc')
                ->get();

Reference

https://laravel.com/docs/8.x/queries#ordering-grouping-limit-and-offset

A regular query

....ORDER BY id DESC ")..........

Please or to participate in this conversation.