Laravel Sorting data from db with where clause

Question

So i have this in my controller

public function index()
{
    $posts = Post::where('reviewed', '=' , 1)->orderBy('created_at', 'DESC');
    $url = asset('img/logo.gif');
    $mytime = Carbon\Carbon::now();
    $this->layout->content = View::make('partials.index', array('posts' => $posts->paginate(9)))->with('img', $url)->with('date' , $mytime);
}

What i want to happen is i want to sort out my post by created_at time stamp but i dont know how to do this properly and this line in $post var ->orderBy('created_at', 'DESC') doesn't seem to work.

so how can i do this properly?

have you seen the return of the posts variable

Oli Soproni B.
– Oli Soproni B.

2015-02-25 05:36:39 +00:00
Commented Feb 25, 2015 at 5:36 — Oli Soproni B.
– Oli Soproni B., Commented Feb 25, 2015 at 5:36

Deenadhayalan Manoharan · Accepted Answer · 2015-02-25 06:26:49Z

1

Try this..

 $posts = Post::orderBy('created_at', 'desc')->where('reviewed', '=' , 1)->get();

answered Feb 25, 2015 at 6:26

Deenadhayalan Manoharan

5,45214 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Deenadhayalan Manoharan Over a year ago

i have add my answer please check it and let me know

DNM Over a year ago

actually my code was working but anyway thanks for helping :) appreciate it much thanks

Bernig · Accepted Answer · 2015-02-26 00:53:27Z

0

I think you forgot to chain the get() method, as stated by Deena.

$posts = Post::where('reviewed', '=' , 1)->orderBy('created_at', 'desc')->get()

Could you please dump your $posts variable and show the result ?

answered Feb 26, 2015 at 0:53

Bernig

4623 silver badges7 bronze badges

Collectives™ on Stack Overflow

Laravel Sorting data from db with where clause

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related