Re: [fw-general] DB_Table

[Ian Warner]

Hi

Ignore this I found it after I wrote it :)

            $table  = new models_admin_Smspending();
            $result = $table->fetchAll();
            $result = $result->toArray();

Cheers

Ian

Ian Warner wrote:

Hi

I want to get at the Results Array after selecting my results from my MySQL View

at the moment this is in _data but it is protected

So i basically want to get

$result = $table->fetchAll()->toArray();

or

$result = $table->fetchAll()->_data;

or something, I throw this array into my HTML table structures.

        // Invoke any needed args from the registry / request
        $db = $this->getInvokeArg('db');

        try {

            Zend_Db_Table::setDefaultAdapter($db);

            $table  = new models_admin_Smspending();
            $result = $table->fetchAll();

            // Invoke any needed args from the registry / request
            $this->view->feature         = parent::getHeader();

$this->view->navigation = $this->getInvokeArg('navigation');

            $this->view->params          = $this->_getAllParams();
            $this->view->result          = $result;
            $this->view->theme           = $this->getInvokeArg('theme');

$this->view->translateModule = $this->_request->translateModule;

        } catch (Exception $e) {
            echo 'Failed: ' . $e->getMessage();
        }