Forum Problem with Eloquent 'orWhere' clause

tylerwilcock

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

firtzberg

replied 10 years ago

Solution

Try this

            ->where('checkout.emplid', '<>', 0)
            ->where(function($query)
            {
                $query->where('deviceList.billable', '<>', 'No')
                      ->orWhere('deviceList.prorateable', '<>', 'No');
            })

Last updated 2 years ago.

Your banner here too?

TylerWilcock tylerwilcock Joined 11 Jun 2014

Moderators

driesvints Joined 16 Dec 2013
joedixon Joined 23 Jun 2014
tvbeek Joined 8 Jan 2018

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

Your logo here?

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

Laravel.io

Forum Articles Pastebin

Socials

(Twitter) Bluesky GitHub

The community

Laravel

Laravel News

Laracasts

Laravel Podcast