increment a field in query builder

Question

increment a field in query builder

Richard Mar '14

Created Mar '14	Last Reply Mar '14	Replies 1	Views 812	Votes 0

Richard 9.2k

Mar '14

Does the query class support incrementing a field like this?

$query = new Query("UPDATE MyList SET orderNumber = orderNumber + 1 WHERE orderNumber >= ?0 AND listId = ?1",$di);
$query->execute(array($moveTo,$myList->id));

Aboozar Ghaffari · Answer 1 · 2014-03-05T06:42:17-07:00

Yes, run it like this:

$query = new Query("UPDATE MyList SET orderNumber = orderNumber + 1 WHERE orderNumber >= ?0 AND listId = ?1",$di);

$query->execute(array(
    0 => $moveTo,
    1 => $myList->id
    ));

Richard · Answer 2 · 2014-03-07T10:25:13-07:00

Richard
9.2k

Mar '14

Why would adding the deafult array keys make a difference? Have you actually tried it?