4
$conn  = Mage::getSingleton('core/resource')->getConnection('core_write');
$sql = "UPDATE ...";
$result = $conn->query($sql);

How do I get the number of affected rows - i.e. mysql_affected_rows();

2 Answers 2

5

Instead of using the $conn->query() you could use $conn->update(). This takes the following parameters:

  1. The table that you want to update,
  2. An array of column value pairs,
  3. The where clause of your statement

It will return the number of affected rows. This is also true for the delete and different insert functions. You can find the basics of the functions under Varien_Db_Adapter_Interface. Or for a good example have a look at decrementProducts in Mage_Tag_Model_Resource_Tag

EDIT

If you want to perform an insert on duplicate key update then use the function insertOnDuplicate. This takes the following parameters:

  1. The table that you want to insert into,
  2. An array of column value pairs,
  3. An array of columns to update,

A good example of this can be found in the saveSelectionPrice function under Mage_Bundle_Model_Resource_Selection

3
  • what would I use for an "INSERT ... ON DUPLICATE KEY UPDATE"
    – sdfor
    Nov 11, 2013 at 14:25
  • There is an insertOnDuplicate function. But the parameters due vary from the normal insert Nov 11, 2013 at 17:13
  • @sdfor I have updated my answer to include information about the insertOnDuplicate function Nov 13, 2013 at 12:25
2

Try with this.

  <?php
    $sql = "UPDATE ...";
    $result = $read->fetchAll($sql);
    $total_rows = count($result);
    ?>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.