[Flashy]

When I use the "set_relation" function, how can I use a different database column value for the selects option value that is output?

 

Is the default valued used when rendered the tables Primary key value? - how can I use a value from another column?

 

 

My Code:

 

$this->crud->set_relation('show','statuses','title', array('group' => 'yn'));

 

This is the database structure of the statuses table:

 

CREATE TABLE `statuses` (

  `id` int(4) NOT NULL AUTO_INCREMENT,

  `title` varchar(100) NOT NULL,

  `slug` varchar(100) NOT NULL,

  `value` int(4) NOT NULL DEFAULT '0',

  `group` varchar(100) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

 

 

I want to use the "value" column results not the id column

 

[Flashy]

Worked it out incase anybody else needs to know:

 

Set the primary key of the table before calling set_relations...

 

$crud->set_primary_key('value','statuses');

$crud->set_relation('show_in_navi','statuses','title', array('group' => 'yn'));

 

[Flashy]

 

Worked it out incase anybody else needs to know:

 

Set the primary key of the table before calling set_relations...

 

$crud->set_primary_key('value','statuses');

$crud->set_relation('show_in_navi','statuses','title', array('group' => 'yn'));

 

So it seems that when you do this, it doubles up the data being returned, so I still need an answer to this...

[Dennis Ayala]

So it seems that when you do this, it doubles up the data being returned, so I still need an answer to this...

 

I'm interested to know the answer for this question. Anyone?