Wannabe question find($id) vs fetchRow("id = $id")

matias.quaglia · #1 (**permalink**) 08-07-2007, 12:11 PM

Hi, i'm trying to understand the differences between the find($id) method and the fetchRow("id = $id") method.

When I try to use find, i get that i don't get any row, but when i use fetchRow I do.

Please could something explain me a little about this?

Here I paste something of my controller action:

With find (it seems that i don't get the row)

PHP Code:


			
            $id = $this->_getParam('id');

            

            $imagen = new Image();

            

            $imagenData = $imagen->find($id);

            

            if ($imagenData) {

                $this->view->imagen = $imagenData;

                $this->view->error = 0;

            } else {

                $this->view->error = 1;

                $this->view->mensaje = "La imagen pedida ya no existe";

            }

And with fetchRow (it works really fine):

PHP Code:


			


            $id = $this->_getParam('id');

            

            $imagen = new Image();

            

            $imagenData = $imagen->fetchRow("id = $id");

            

            if ($imagenData) {

                $this->view->imagen = $imagenData;

                $this->view->error = 0;

            } else {

                $this->view->error = 1;

                $this->view->mensaje = "La imagen pedida ya no existe";

            }

aaaa0441 · #2 (**permalink**) 09-03-2007, 10:38 AM

fetchRow () returns a row
but find () returns a rowset

so, basically you can use find() like this:

PHP Code:


			
$rows = $imagen->find($id);

$imagenData = $rows[0];

Please refer to the API doc:
Docs For Class Zend_Db_Table_Abstract

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode