How to use variable in Active record SELECT

[eluser]wowdezign[/eluser]
Did you try this?

Code:

function findOrphans($segment, $id, $db_table){
     $tablename = explode("-", $db_table);
    $tableid = $tablename[1]."_id";
    
    $data = array();
     $this->db->select($tableid.',name');