I have written laravel query.in this query i am using wherebetween and orwherebetween.also one where statement column named 'shareable' which should return the rows equal to one.but this query does not takes where condition into consideration.it tooks only wherebetween and orwherebetweens.what can be the reason.
my query
$childs = Program::whereIn('id', $programs_by_date)
->where('shareable', '=','1')
->wherebetween('starting_date', [$new_start_date,$new_end_date])
->orwherebetween('ending_date', [$new_start_date,$new_end_date])
->orderBy('starting_date')
->get();
->where('shareable', '=','1') this returns 0 value rows also.what can be the reason.'shareable' type is enum
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire