// Method one : use Set::extract()
$data = $this->Attribute->findAll(...);
$ids = Set::extract($data, '{n}.Attribute.id});
$status_arr = array_combine($ids, Set::extract($data,
'{n}.Attribute.status'));
$value_arr = array_combine($ids, Set::extract($data,
'{n}.Attribute.value'));
...
// Method two: do it manually
$fieldsIWant = array('status', 'value', ...);
$extractedData = array();
$data = $this->Attribute->findAll(...);
foreach ($data as $row) {
$id = $row['Attribute']['id'];
foreach ($fieldsIWant as $field) {
$extractedData[$field][$id] = $row['Attribute'][$field];
}
}
// Now call $this->set('my_status_arr', $extractedData['status']), ...
On Dec 3, 5:42 am, salimk786 <[EMAIL PROTECTED]> wrote:
> I have this table:
>
> CREATE TABLE `attributes` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `controller` varchar(25) default NULL,
> `category` varchar(25) NOT NULL,
> `item` varchar(25) NOT NULL,
> `value` varchar(50) NOT NULL,
> `created` datetime default NULL,
> `modified` datetime default NULL,
> PRIMARY KEY (`id`)
> )
>
> //sample data
> INSERT INTO `attributes` VALUES(1, 'Profiles', 'Basics', 'Lookingto',
> 'Friendship', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(2, 'Profiles', 'Basics', 'Lookingto',
> 'A Relationship', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(6, 'Profiles', 'Basics',
> 'Relationshipstatus', 'Single', '0000-00-00 00:00:00', '0000-00-00
> 00:00:00');
> INSERT INTO `attributes` VALUES(7, 'Profiles', 'Basics',
> 'Relationshipstatus', 'Committed', '0000-00-00 00:00:00', '0000-00-00
> 00:00:00');
> INSERT INTO `attributes` VALUES(11, 'Profiles', 'Basics', 'Bodytype',
> 'Slim', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(12, 'Profiles', 'Basics', 'Bodytype',
> 'Slender', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(72, 'Profiles', 'Lifestyle',
> 'Drinker', 'Yes', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(73, 'Profiles', 'Lifestyle',
> 'Drinker', 'No', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
> INSERT INTO `attributes` VALUES(74, 'Profiles', 'Lifestyle',
> 'Drinker', 'I will tell you later', '0000-00-00 00:00:00', '0000-00-00
> 00:00:00');
>
> --> I do not like doing this:
> $this->set('arr_attribute_idlookingTo',$this->Attribute->generateList(array('controller'
> => $this->name, 'category' =>
>
> 'Basics', 'item' => 'Lookingto'), 'id ASC', 0, '{n}.Attribute.id',
> '{n}.Attribute.value'));
> $this->set('arr_attribute_idrelationshipstatus',$this->Attribute->generateList(array('controller'
> => $this->name, 'category' =>
>
> 'Basics', 'item' => 'Relationshipstatus'), 'id ASC', 0,
> '{n}.Attribute.id', '{n}.Attribute.value'));
> $this->set('arr_attribute_idlifestyle',$this->Attribute->generateList(array('controller'
> => $this->name, 'category' =>
>
> 'Basics', 'item' => 'Lifestyle'), 'id ASC', 0, '{n}.Attribute.id',
> '{n}.Attribute.value'));
>
> I dont' like doing that because i am querying the database so many
> times.
> I'd rather do a findAll $condtions = array('controller' => $this->name)
>
> and then somehow call the getFieldValue to do whatever it does
> that takes keys and values out of the data from the findAll...
>
> Can someone tell me how i can call getFieldValue and pass it the data
> of interests ?
>
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
