#24540 [Opn->Fbk]: sqlite_seek()
| From: | wez@php.net | Date: | Tue, 08 Jul 2003 16:32:09 +0000 |
| Subject: | #24540 [Opn->Fbk]: sqlite_seek() | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-43460@lists.php.net to get a copy of this message | ||
ID: 24540
Updated by: wez@php.net
Reported By: info at php-power dot it
-Status: Open
+Status: Feedback
Bug Type: SQLite related
Operating System: Windows XP
PHP Version: 5.0.0b1 (beta1)
New Comment:
So is it working?
If not, can you clarify what the problem is? :)
Previous Comments:
------------------------------------------------------------------------
[2003-07-08 11:20:38] info at php-power dot it
I'm tired, naturally sqlite_seek() does not have the sign $
:)
------------------------------------------------------------------------
[2003-07-08 11:16:16] info at php-power dot it
Excused:
sqlite_seek() moves the pointer ahead to record requested
Example:
$sqlite_seek($result, 1);
sqlite_current($result);
result: 2 row of table
$sqlite_seek($result, 3);
sqlite_current($result);
result: 3 row of table
etc ...
------------------------------------------------------------------------
[2003-07-08 10:56:05] info at php-power dot it
Description:
------------
The function sqlite_seek() not return a requested line,
but the row successive.
Reproduce code:
---------------
$result = sqlite_query('SELECT * FROM test', $conn);
if (sqlite_seek($result, 1)) {
$row = sqlite_current($result, SQLITE_NUM, true);
}
Expected result:
----------------
The first row of table.
Actual result:
--------------
The secon row of table.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24540&edit=1