/** * Display a listing of the resource. * GET /site\event * * @return Response */ public function index() { View::share('title', 'Események'); $events = Event::where('shows', '=', true)->orderBy('start', 'DESC')->select(['id', 'title', 'start', 'end', 'content'])->paginate(10); $events = Event::whereRaw('shows = ? ORDER BY start DESC', array(true))->paginate(10); $this->layout->content = View::make('site.event.index')->with('events', $events); }