Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
run SUM function in DB
  • manhthang2504manhthang2504
    I want to run this SQL
    SELECT SUM(start_time - stop_time), job from timesheets GROUP BY job

    How can I perform it in FuelPHP?
    Thank you
  • HarroHarro
    Accepted Answer
    I would say:

    $result = \DB::select(\DB::expr("SUM(start_time - stop_time)"), 'job')
        ->from('timesheets')
        ->group_by('job')
        ->execute();
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