[SOLVED]How to update database by a raw sql?

Question

Jimmy Chandra Jun '13

Created Jun '13	Last Reply Jun '13	Replies 1	Views 753	Votes 1

Jimmy Chandra 21.5k

Dear experts,

I want to execute raw simple query like:

UPDATE comments SET sort_order = :order: WHERE id = :id:

How to do that in Phalcon?

PS: I try to avoid PHQL because I read that it will do select first then update (2 round database trips)

Thanks

Jim

Andrey · Answer 1 · 2013-06-27T03:41:12-07:00

$this->db->query("UPDATE comments SET sort_order = ? WHERE id = ? ", array($sort_order, $comment_id));

Tested it and it doesn't select table schema before update.

Jimmy Chandra · Answer 2 · 2013-09-29T20:43:01-07:00

Jimmy Chandra
21.5k

@Andrey It works. Thanks.