Obtaing A Single Model Instance Based On SQL Constraint

conradwt · #1 (**permalink**) 12-13-2007, 02:11 AM

Hi, why doesn't the following return a rowset containing one row? In short, I have a model called Animal and I would like to get a row based on a constraint:

PHP Code:


			
function updateAction() {

        $this->view->title = "Update Animal";

        $episode = new Animal();
        $sql = "SELECT * FROM animals WHERE is_rare = 1 ORDER BY id DESC LIMIT 1";
        $this->view->currentAnimal = $animal->fetchAll( $sql );

      }

troxy · #2 (**permalink**) 12-13-2007, 07:41 AM

$this->view->currentAnimal is a rowset object, because fetchAll() always returns a rowset, even if only one row is found. You can use current() on the rowset to fetch the single row.
Or use fetchRow() on the table instead, because it returns the first row returned by the query.

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