There's no mystery (especially if you read the guide). As I said, if you don't include the create statement you are not creating a new record (the value of $this->id hasn't changed) therefore you stay on the first record you create or navigate to and only ever update.
Jeremy Burns Class Outfit [email protected] http://www.classoutfit.com On 28 Mar 2011, at 18:42, Rishab Jain wrote: > Thanks Jeremy. It worked. > > If possible, do feed in your 2 cents on how this worked. > > regards, > Rishab > > On 3/28/11, Jeremy Burns | Class Outfit <[email protected]> wrote: >> Add $this->create(); to your loop before you do the save. If not, you are >> just updating the same record. >> >> Jeremy Burns >> Class Outfit >> >> [email protected] >> http://www.classoutfit.com >> >> On 28 Mar 2011, at 16:21, Rishab Jain wrote: >> >>> Hi All, >>> >>> I'm facing a very weird problem. I'm trying to save data in a loop >>> where 1 person is sending msg to many people.. Here's the print_r of >>> the 3 arrays before I call the 'save' function in the model. >>> >>> Array >>> ( >>> [Message] => Array >>> ( >>> [sender_uid_fk_users] => 1 >>> [subject] => hey >>> [body] => hey >>> [recipient_uid_fk_users] => 2 >>> [date] => 2011:03:28 10:52:41 >>> ) >>> >>> ) >>> Array >>> ( >>> [Message] => Array >>> ( >>> [sender_uid_fk_users] => 1 >>> [subject] => hey >>> [body] => hey >>> [recipient_uid_fk_users] => 4 >>> [date] => 2011:03:28 10:52:41 >>> ) >>> >>> ) >>> Array >>> ( >>> [Message] => Array >>> ( >>> [sender_uid_fk_users] => 1 >>> [subject] => hey >>> [body] => hey >>> [recipient_uid_fk_users] => 6 >>> [date] => 2011:03:28 10:52:41 >>> ) >>> >>> ) >>> >>> The only difference here is the different 'recipient_uid_fk_users' in >>> all the 3 arrays with values '2', '4', and, '6'. >>> >>> All I'm doing then is, >>> foreach(recipient...) >>> { >>> /// prepare $arrayMessagesInfo ///// >>> $this->save($arrayMessagesInfo); >>> } >>> >>> The issue I'm facing is that only the first value gets inserted, and >>> the rest of the two queries becomes 'update' queries. I'm not even >>> mentioning the primary key in the array. >>> >>> These are the cakephp debugging logs: >>> >>> 4 INSERT INTO `messages` (`sender_uid_fk_users`, `subject`, >>> `body`, `recipient_uid_fk_users`, `date`) VALUES (1, 'hey', 'hey', 2, >>> '2011:03:28 10:48:33') 1 0 >>> 5 SELECT LAST_INSERT_ID() AS insertID 1 1 0 >>> 6 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE >>> `Message`.`id` = 3 1 1 0 >>> 7 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE >>> `Message`.`id` = 3 1 1 0 >>> 8 UPDATE `messages` SET `sender_uid_fk_users` = 1, `subject` = >>> 'hey', `body` = 'hey', `recipient_uid_fk_users` = 4, `date` = >>> '2011:03:28 10:48:33' WHERE `messages`.`id` = 3 1 >>> 0 >>> 9 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE >>> `Message`.`id` = 3 1 1 0 >>> 10 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE >>> `Message`.`id` = 3 1 1 0 >>> 11 UPDATE `messages` SET `sender_uid_fk_users` = 1, `subject` = >>> 'hey', `body` = 'hey', `recipient_uid_fk_users` = 6, `date` = >>> '2011:03:28 10:48:33' WHERE `messages`.`id` = 3 >>> >>> Here's the table structure: >>> CREATE TABLE `messages` ( >>> `id` int(10) unsigned NOT NULL AUTO_INCREMENT, >>> `subject` varchar(100) NOT NULL, >>> `body` varchar(500) NOT NULL, >>> `sender_uid_fk_users` int(10) unsigned NOT NULL, >>> `date` datetime NOT NULL, >>> `recipient_uid_fk_users` int(10) unsigned NOT NULL, >>> PRIMARY KEY (`id`), >>> KEY `sender_uid_fk_users` (`sender_uid_fk_users`), >>> KEY `recipient_uid_fk_users` (`recipient_uid_fk_users`), >>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | >>> >>> >>> It would be great if anybody can help me out here. >>> >>> regards, >>> Rishab >>> >>> -- >>> Our newest site for the community: CakePHP Video Tutorials >>> http://tv.cakephp.org >>> Check out the new CakePHP Questions site http://ask.cakephp.org and help >>> others with their CakePHP related questions. >>> >>> >>> To unsubscribe from this group, send email to >>> [email protected] For more options, visit this group >>> at http://groups.google.com/group/cake-php >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> [email protected] For more options, visit this group at >> http://groups.google.com/group/cake-php >> > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
