Ah, here's another one, this will display a user's avatar using
{$avatar} in the template:
PHP Code:
$profile = $mysidia->db->select("users_profile", array("uid", "avatar"), "username = '{$mysidia->user->username}'")->fetchObject();
$img = "<img src='../../".$profile->avatar."' class='avatar'>";
$this->assign("avatar",$img);
I have it creating an image with a class of 'avatar' which you can set into your css stylesheet to have set dimensions of your choosing. ^^