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
-~----------~----~----~----~------~----~------~--~---