Fatal error: Cannot use object of type stdClass as array in

Question

I'm getting the error:

"Fatal error: Cannot use object of type stdClass as array in" on line 183

From this code:

$getvidids = $ci->db->query(     "SELECT * FROM videogroupids " .      "WHERE videogroupid='$videogroup' AND used='0' LIMIT 10");  foreach ($getvidids->result() as $row){     $vidid = $row['videoid'];              //This is line 183 } 

Anyone know what's wrong with the above code? Or what this error means?

Answer 1

CodeIgniter returns result rows as objects, not arrays. From the user guide:

result()

---

This function returns the query result as an array of objects, or an empty array on failure.

You'll have to access the fields using the following notation:

foreach ($getvidids->result() as $row) {     $vidid = $row->videoid; } 

Answer 2

if you really want an array instead you can use:

$getvidids->result_array() 

which would return the same information as an associative array.