help in getting and displaying info from database

[eluser]Ben Swinburne[/eluser]
In response to a private message, for the benefit of any other readers.

hey thank you for helping me out. but i have a question
was my model correct? what i was trying to do was get the firstname from my db and then display it in my view but it doesnt, where did i do wrong?

Typically I'd have achieved what you're trying to do like this:

Model

Code:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Profile extends CI_Model {  
    function get_info($username) {
      $this->load->database($dsn);
      return $this->db->select('firstname')->get_where('users', array('username', $username))->result_array();
    }

}

?>

Controller

Code:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Profilepage extends CI_Controller {
    function index() {
        $this->load->model('Profile');
        if( $this->input->post('username') ) {
                $data = $this->Profile->get_info($this->input->post('username'));
                $this->load->view('profile', $data);
        } else {
                show_error("You've not submitted a username");
        }
    }
}

?>

View

Code:

<?php echo $firstname; ?>

I've not commented it but if you have any questions, just ask (in the thread).