Note the upgraded forum! If you are experiencing issues logging in, you may need to reset your password which should send an email. If the email doesn't arrive, be sure to check your spam folder just in case.

How to display two columns in a has_many relationship multifield ?

edited September 2017 in Modules
Hello,
i try to display two columns in a supercomboselect : only the first column after id in the table is visible ?

i.e. i try to display first_name and name of guests in my simple module 'events'.

thks for an idea or a clue.

Comments

  • edited 1:11AM
    forget my question. sorry.
    i found : i ve override options_list function in my foreign table model :

    public function options_list($key = NULL, $val = NULL, $where = array(), $order = TRUE)
    {

    $this->db->order_by($this->table_name . '.name', 'asc');
    $this->db->select($this->table_name . '.id,' . $this->table_name . '.name,' . $this->table_name . '.first_name', FALSE);

    if (!empty($where)) {
    $this->db->where($where);
    }
    $query = $this->db->get($this->table_name);
    if (!empty($query)) {
    $results = $query->result_assoc_array('id');
    $returns = array();
    foreach ($results as $k => $val) {
    $returns[$k] = $val['name'] . ' ' . $val['first_name'];
    }
    return $returns;
    }
    return FALSE;
    }

    everything seems to be ok.

    have a nice day.
Sign In or Register to comment.