Re: limitQuery

From:	Roger Spears	Date:	Tue, 18 May 2004 16:49:35 +0000
Subject:	Re: limitQuery
References:	1 2	Groups:	php.pear.general
Request:	Send a blank email to pear-general+get-12571@lists.php.net to get a copy of this message

Brent Baisley wrote:

You should try using 0,4. Typically references start at 0, like in arrays.

Anytime I use 0 there are no results returned. Thanks, Roger

On May 18, 2004, at 12:01 PM, Roger Spears wrote:
Hello, I'm using PEAR to query an Oracle database. I'm wondering if anyone else has experience with this combination because when I use limitQuery, I'm never able to retrieve the very first record. It's not a big problem for me as far as functionality goes, but I'm curious if I'm doing something wrong... I'm trying to grab records 1 through 5. Here's my statement: $res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 1, 5); Oddly enough, it returns record 2 through 6. I've tried to use 0 and 5, but that doesn't return anything. I'm unable to get that very first record.?.?. Can anyone point out if I'm doing something wrong? Thanks, Roger