Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Need Syntax of between in query builder
  • unnatithakurunnatithakur
    hello

    i need help stuck in code

    $result =  DB::select('*')
                    ->from('sim_status')
                 ->where('reserve_now.rdate','BETWEEN',$arrayvalue['startdate'],$arrayvalue['enddate'])
                    ->execute();


    syntax error is coming in above code. please reply
  • HarroHarro
    Multiple values are not supported in a where clause. The way around it is to use DB::expr():

    where('reserve_now.rdate', 'BETWEEN', DB::expr($arrayvalue['startdate'].' AND '.$arrayvalue['enddate']));
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion