Support the ongoing development of Laravel.io →
Database Eloquent
Last updated 2 years ago.
0
$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.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Donny5300 donny5300 Joined 3 May 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.

© 2024 Laravel.io - All rights reserved.