public function show($title, $id) { if ($id == "") { return ""; } $data["question"] = Questions::with('question_classif')->where('id', $id)->first(); // print_r($data["question"]); /* clients can see only question with status 0002 */ if (!Auth::check() && $data["question"]->status != '0002') { return redirect('/questions'); } $data['answers'] = Answers::where('qid', $id)->get(); $data['tags'] = DB::table('questions_tags')->join('questions_tags_rel', 'questions_tags.id', '=', 'questions_tags_rel.tid')->where('questions_tags_rel.qid', '=', $id)->get(); return view('questions/question', $data); }