limitQuery
| From: | Roger Spears | Date: | Tue, 18 May 2004 16:01:06 +0000 |
| Subject: | limitQuery | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-12568@lists.php.net to get a copy of this message | ||
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