update query in symphony (Method 2)

For example to execute query like

UPDATE tableName SET column1 = 'abc',column2 = 'xyz' WHERE column ='1';

In symfony you can do it this way

$c = new Criteria();
$c->add(MyTablePeer::COLUMN,1);
$c->add(MyTablePeer::COLUMN1,'abc');
$c->add(MyTablePeer::COLUMN2,'xyz');
MyTablePeer::doUpdate($c);

Thanks

Leave your comment

  • Renjith

    How this criteria works with more than one ‘where’ conditions like this?
    WHERE column1 =’1′ and column2 =’1′