# Update query and affected rows

**URL:** <https://discourse.cakephp.org/t/update-query-and-affected-rows/10631>\
**Category:** Need Help\
**Created:** [September 16, 2022, 1:44pm UTC](https://discourse.cakephp.org/t/update-query-and-affected-rows/10631 "2022-09-16T13:44:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadowx.jb](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@shadowx.jb](https://discourse.cakephp.org/u/shadowx.jb)\
**Post date:** [September 16, 2022, 1:44pm UTC](https://discourse.cakephp.org/t/update-query-and-affected-rows/10631/1 "2022-09-16T13:44:05Z")

</div>

I have query update…

```auto
$this->GoodsItems->query()
    ->update('goods_items g, imports i')
    ->set([
        'g.price = i.price',
    ])
    ->where([
        'g.code = i.code',
    ])
    ->execute();

```

Can i get the `ID`s that have been updated from table `goods_items`?

Thank you

---

<div class="post-metadata">

**Author:** ![jarekgol](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jarekgol](https://discourse.cakephp.org/u/jarekgol)\
**Post date:** [September 17, 2022, 3:23pm UTC](https://discourse.cakephp.org/t/update-query-and-affected-rows/10631/2 "2022-09-17T15:23:37Z")

</div>

try add before some `$variable = `  
and `debug($variable);` after.

---

<div class="post-metadata">

**Author:** ![mvojwe](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@mvojwe](https://discourse.cakephp.org/u/mvojwe)\
**Post date:** [September 21, 2022, 6:51pm UTC](https://discourse.cakephp.org/t/update-query-and-affected-rows/10631/3 "2022-09-21T18:51:03Z")

</div>

You’re looking for the function [rowCount()](https://api.cakephp.org/4.4/class-Cake.Database.Log.LoggingStatement.html#rowCount()).

If you don’t have intellisense, you can use get\_class() on the $query object and search for that class on the CakePHP API.

```auto
$query = $this->GoodsItems->query()
    ->update('goods_items g, imports i')
    ->set([
        'g.price = i.price',
    ])
    ->where([
        'g.code = i.code',
    ])
    ->execute();

debug(get_class($query));
debug($query->count());
die;

```
