Getting a users name from id

[eluser]cahva[/eluser]
Didnt you say you could do it "oldschool" Its a simple mysql query, just like "oldschool" unless you want to use active record.

I dont know the fields but it should look something like this(and put your database related things in model):

Code:

class Posts_model extends Model {
    
    function __construct()
    {
        parent::__construct();
    }
    
    function get_all()
    {
        $this->db->select('*')
                ->from('posts')
                ->join('users','users.id = posts.uid');
                
        $query = $this->db->get();
        
        return $query->result_array();
    }
}

Theres select('*') but you should put the fields you are going to use there.

Then in the controller:

Code:

$this->load->model('posts_model','posts');
$content['posts'] = $this->posts->get_all();

Look in the user guide for more information about active record.