mardi 30 janvier 2018

get all likes agains an answer laravel eloquent

i trying to get all likes against an answer. this is what i have come with soo far. but now i don't know what should i do.

    return DB::table('answers')
                    ->join('member','answers.answer_member_fk','=','member.member_id')
                    ->select('answers.*','member.full_name','member.user_name','member.profile_photo',DB::raw('count(ans_likes.ans_like_id) as total_likes '))
                    ->leftjoin('ans_likes','answers.answer_id','=','ans_likes.ans_like_answer_fk')
                    ->where('answers.answer_question_fk','=',$question_id)
                    ->groupBy('answers.answer_id')
                    ->get();

it is giving me Syntax error or access violation: 1055error according to this error i have to add all the selected columns to groupby. which i think is not a good idea to do so. kindly guide me.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire