Is fetchAll returning wrong rowset?

conradwt · #1 (**permalink**) 01-06-2008, 01:12 AM

Hi, I'm using fetchAll as follows:

PHP Code:


			
$where   = null;
$orderBy = 'id DESC';
$count = null;
$offset = 4;
$recents = $episode->fetchAll( $where, $orderBy, $count, $offset );

Now, when the above code is executed, it's returning all the items in the underlying table and not recognizing that the $offset = 4. If any has any ideas, it would be greatly appreciated.

Thanks in advance,

-Conrad

zeus · #2 (**permalink**) 05-10-2008, 12:54 PM

i guess it should be like this

PHP Code:


			


// Fetching a rowset

   

recents = $episode->fetchAll($episode->select()->where('bug_status = ?','NEW')

                                                                  ->order('bug_id ASC')

                                                                   ->limit(10, 0));

pass your variables in where, order, limit etc.

correct me if i am wrong

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