FuelPHP Forums

ivar

How can I do this query with the DB class? "UPDATE scoreboard SET score = score + 1 WHERE uid = $uid" The "score + 1" is the part I'm wondering about Thanks

Harro

$result = DB::update('scoreboard')
    ->value("score", DB::expr("score + 1"))
    ->where('uid', '=', $uid)
    ->execute();

See http://docs.fuelphp.com/classes/database/usage.html#/escaping

ivar

thank you Harro

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion