Level 30
Try
DB::table('subjects')->orderBy('name', 'desc')->get()
or
Subject::orderBy('name','desc')->get()
Aug 27, 2020
3
Level 2
DB::table query error
I'm trying to run a query with orderBy using DB::table('subjects')->orderBy('name', 'desc') but it throws an error Undefined property: Illuminate\Database\MySqlConnection::$id.
If I do query like this Subject::all() or any of these - it works fine.
I tried with use DB or use Illuminate\Support\Facades\DB but none of them work.
My model is Subject and table is called subjects
What am I doing wrong?
Level 2
I was missing ->get() at the end :-(((
Thnx
Level 30
you welcome. don't forget to mark as best answer :)
Please or to participate in this conversation.