[naveen]

HI this is naveen.

I have a one doubt,
how do i get the state from DB while select the country.

this is my code

public function manageUsers()
{

$crud = new grocery_CRUD();
$crud->set_table('tb_users');
$crud->columns('email','fname','lname','dob','gender','country','state','city','address');
$crud->display_as('fname','First Name ')
->display_as('lname','Last Name')
->display_as('dob','Age');
$this->grocery_crud->unset_columns('user_password','subscribed_date');
$this->grocery_crud->set_rules('email', 'email','trim|required|xss_clean|callback_username_check');
$crud->fields('email','fname','lname','dob','gender','country','state','city','address');
$this->grocery_crud->set_subject('USER');

$crud->callback_column('state',array($this,'getState'));
//get the country and State name while performing JOIN operation
$crud->set_relation('country','tb_countries','country');
$crud->set_relation('state','tb_states_master','State_Name');

$output = $crud->render();
$this->_example_output($output);
}}


By default select the country it and in state it display all states my database. how to solve this one?

[web-johnny]

/topic/127-select-based-on-a-previous-select/page__view__findpost__p__435