# Cannot save data in DB

**URL:** <https://discourse.cakephp.org/t/cannot-save-data-in-db/7145>\
**Category:** Need Help\
**Created:** [January 22, 2020, 1:25am UTC](https://discourse.cakephp.org/t/cannot-save-data-in-db/7145 "2020-01-22T01:25:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anatoliy](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@Anatoliy](https://discourse.cakephp.org/u/Anatoliy)\
**Post date:** [January 22, 2020, 1:25am UTC](https://discourse.cakephp.org/t/cannot-save-data-in-db/7145/1 "2020-01-22T01:25:07Z")

</div>

I have a table with many-to-many relationships. I want to save the data in an intermediate table, but nothing happens.

it`s my controller :

```
public function cart()
{
    $order = $this->Clients_products->newEntity();

    if ($this->request->is('ajax')) {
        $order->client_id = 2;
        $order->product_id = 2;

        if ($this->Clients_products->save($order)) {
            $this->Flash->success(__('OP!! OP!! OP!!.'));
        }else{
            $this->Flash->success(__('Hyi v sraky jitsa v rot.')); 
        }
    }
}

```

it`s my BD :

![image](https://canada1.discourse-cdn.com/flex029/uploads/cakephp/original/2X/3/35f13716cf1a9c488ba44a6ee2070056492e221e.png)

---

<div class="post-metadata">

**Author:** ![Zuluru](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/zuluru/32/1230_2.png) [@Zuluru](https://discourse.cakephp.org/u/Zuluru)\
**Post date:** [January 22, 2020, 2:06am UTC](https://discourse.cakephp.org/t/cannot-save-data-in-db/7145/2 "2020-01-22T02:06:06Z")

</div>

What do you mean by “nothing happens”? You get no message at all? Success message but it didn’t save? Failure message?

---

<div class="post-metadata">

**Author:** ![Anatoliy](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@Anatoliy](https://discourse.cakephp.org/u/Anatoliy)\
**Post date:** [January 22, 2020, 11:45am UTC](https://discourse.cakephp.org/t/cannot-save-data-in-db/7145/3 "2020-01-22T11:45:15Z")

</div>

I solved this problem myself. It was necessary to add a field with a primary key to the table.

Thank you for your time