You should make a a practice to call $this->Model->create() before
every insert.

So in this example..

$this->ContentBlock->create();
$this->ContentBlock->save( $quote );
...

$this->ContentBlock->create();
$this->ContentBlock->save( $header );

On Apr 25, 10:11 am, Mike Digital Egg <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I am having a problem trying to save 2 different values to a single
> table, below is the code:
>
> if ( $_POST["data"]["Block"][1] ) {
>         $quote = array(
>                 'content_id' => $id,
>                 'block_id' => $_POST["data"]["Block"][1]["id"]
>         );
>         $this->ContentBlock->save( $quote );}
>
> if ( $_POST["data"]["Block"][2] ) {
>         $header = array(
>                 'content_id' => $id,
>                 'block_id' => $_POST["data"]["Block"][2]["id"]
>         );
>         $this->ContentBlock->save( $header );
>
> }
>
> INSERT INTO `content_blocks` (`content_id`,`block_id`) VALUES
> ('22','1')
> SELECT COUNT(*) AS count FROM `content_blocks` WHERE (`id` = '59')
> UPDATE `content_blocks` SET `content_id` = '22',`block_id` = '8' WHERE
> `id` = '59'
>
> It is inserting the first request but then overwriting it with the
> second, rather than adding a new entry.
>
> Is there a better way of doing this.
>
> Thanks
>
> Mike


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to