Getting a users name from id

[eluser]egunay[/eluser]
@mattpointblank:

Thank you for your answer but unfortunately it is not the way that I was looking. I mean;

As I'm getting the timestamp in array and parsing it to the view doing it this way doesn't work.

For example, this is my controller:

Code:

$entries = $this->db->query("SELECT * FROM posts INNER JOIN users ON posts.uid=users.uid");
$content['posts'] = $entries->result_array();
$this->parser->parse("/content", $content);

And this is my view;

Code:

{posts}
<div id="post_title">{title}</div>

<div>{username} @ {created}</div> // -> "created" = my timestamp
<hr />
{/posts}

I hope I could have explained what I'm trying to tell