Form field data pulled from database

[eluser]jedd[/eluser]
[quote author="mdcode" date="1237343455"]
Model:

Code:

function get_customers()
    {
        /* customer selection query */
        $this->db->select('*');
        $this->db->from('customers');
        $this->db->order_by("customerName", "ASC");
        $cust_query = $this->db->get();
        
            foreach ($cust_query->result_array() as $row)
            {
            $row['customerid'];
            $row['customerName'];
            }
            
        return $cust_query;
    }

[/quote]

Okay .. what do you believe your indented foreach code there will actually do? I mean, what's the intent of that block, and do you think it delivers?


I suggested using arrays as they're easier for people who aren't used to dealing with objects or AR approaches - so you either need to assign those $row data above to a new array variable and return that OR use the $query->result_array() in the original call (and replace the ->db-> style AR calls) at the same time, OR you modify your view to cope with cycling through an object rather than an array.

Any of these options are open to you - so you pick which one you like the sound of the most, and we'll move forward with that one. At the moment I feel we're trying multiple approaches to the one basic problem.