How to get FetchAll() to return an array in Zend Framework

HI,
     I'm trying to populate a Select aka dropdown in a form.  I have an error that tells me I'm not sending the select an array.  What am I doing wrong.

Catchable fatal error: Argument 1 passed to Zend_Form_Element_Multi::setMultiOptions() must be an array, object
$sites = new Sites();
        $sitelist = $sites->getsitelist();
               
        $site = new Zend_Form_Element_Select('site');
        $site->setLabel('Site')
        ->setRequired(true)
        ->addValidator('NotEmpty', true)
        ->setMultiOptions($sitelist);
 
 
 
 
------------------------------------------------------------------------------------------------------------
 
 
 
class Sites extends Zend_Db_Table_Abstract {
	/**
	 * The default table name 
	 */
	protected $_name = 't_sites';
	
	public function getsitelist()
	{
		
		$sites =new Sites();
		
		return $sites->fetchAll(array('id = id', 'name = name'));
		
	}
 
}

Open in new window

sean-keysAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RurneConnect With a Mentor Commented:
Couple of things I see.

1.  line 28 is a bit confusing... 'id = id' and 'name = name' are reflexive, so this should always match.
2.  fetchAll returns Zend_Db_Rowset_Abstract, not an array.  You can use the toArray() function to break out of the Rowset object... change line 8 to:

->setMultiOptions($sitelist->toArray());
0
 
sean-keysAuthor Commented:
If you are confused there is no hope for me, jk.  

      return $sites->fetchAll()->toArray();     Worked.

But it filled the dropdown with every columns data as a choice , not a rowset.

0
 
sean-keysAuthor Commented:
The blunder at line 28 was an attempt to get one row to show up per selection in the dropdown.
0
All Courses

From novice to tech pro — start learning today.