Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
MySQL Update Column +1
  • arnold0613arnold0613

    $sql="UPDATE table SET count = count +1 WHERE id =1;

    This is wrong

    $result = DB::update('table')
    ->value("count ",'count +1')
    ->where('id','=','1')
    ->execute();

    How can I modify

  • HarroHarro
    To prevent the query builder from escaping or quoting your expression, you have to tell it you're defining an expression, and not a literal or a column name:

    $result = DB::update('table')
    ->value("count ",DB::expr('count +1'))
    ->where('id','=','1')
    ->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