CodeIgniter Forums

Full Version: newbie problem assigning result of query to a field.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

I’m trying to populate a field on a new record with the results of a Select_max query.
I’m getting the proper result from the query, but i’m doing something dumb in my set_fields function.
Via debug i can see the result of query gets the correct value, but i’m not getting $fields[‘TAPEID’] loaded.

Probably a super simple problem, but i’m not sure how to resolve it at the moment.

function _set_fields(){
        $fields['LABEL'] = 'TAPELABEL';
        $fields['TAPEID'] = $this->Tape_model->getMaxTape();
        $fields['SYSTEM'] = 'SYSTEM';
        $fields['LOCATION'] = 'LOCATION';
        $fields['STATUS'] = 'STATUS';
        $fields['NOTES'] = 'NOTES';
function getMaxTape()
        $query = $this->db->get('tstmis.tapeinv');
        return $query->result();

El Forum

You are returning a set of results. You can't assign that to a field?

If you expect 1 row to come out try selecting one row, like $query->row(). Depends a bit on what you want it to display.

Quote:Result(): This function returns the query result as an array of objects, or an empty array on failure.

El Forum

OK, i changed to $query->row();

I still am not getting $fields['TAPEID'] = $this->Tape_model->getMaxTape(); to populate

When i look at debug after this statement, $fields['TAPEID'] shows Object of Confusedtdclass