$events = Event::whereHas('club.city', function ($q) use ($cityname) {
$query->where('name', $cityname);
})->where('accepted', 1)
->with(['club.city', 'organisation'])
->orderBy('created_at', 'asc')
->paginate(6);
assuming the city name is on the city relationship and the field is 'name'.
Last updated
8 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast