Form field data pulled from database

[eluser]jedd[/eluser]

Code:

function get_customers()
    {
        /* customer selection query */
        $this->db->select('customerid', 'customerName');
        $this->db->from('customers');
        $this->db->order_by('customerName');
        $this->db->get();
    }

This is in your model, right? If it's not, then it should be.

In any case, have a re-read of the CI Manual pages on [url="http://ellislab.com/codeigniter/user-guide/database/active_record.html"]Active Record[/url] and [url="http://ellislab.com/codeigniter/user-guide/database/results.html"] Processing database results [/url]

Now I'm not quite sure what to put in the controller to make it pass this into the view, and what attributes to put on the select box to make it display the values -- I'm getting the same errors as before still.

Your last line above - you need to actually use the output of the db->get() function. So instead have something like:

Code:

$foo = $this->db->get();
return $foo;

In your controller, you can process that data like this:

Code:

$customers = $this->projects_model->get_customers();

foreach ($customers->result() as $row)
{
    echo $row->customerid;
    echo $row->customerName;
    echo $row->body;
}

Code is very much untested, of course - as I tend to use this->-db->query() stuff instead of AR.

Btw, I concur with CI's style guide - avoid CamelCase (ItBlowsBigTime) - use underscores between words instead. Also you almost definitely do not want a customerid column in a table called customer. Just call it id instead. Ditto for 'customer.customerName' (etc).