Support the ongoing development of Laravel.io →
Requests Eloquent

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?

Last updated 2 years ago.
0

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()}}

Last updated 2 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

babrah babrah Joined 6 Mar 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.