I want to display 'Recent Comments' from comments table, including HotelName related to that Comments. which is working fine as my below query:
Comment::with('hotel')->where('active', '=', 1)->orderBy('created_at', 'DESC')->get();
Now i want to display TOTAL REVIEWS with each HotelName also, how can I do that?
no issue, got it solved : Comment::with('hotel', 'hotel.comments')->where('active', 1)->orderBy('created_at', 'desc')->take(4)->get();
and then in foreach: {{$comment->hotel->comments()->where('active',1)->count()}}
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community