ID: 24540
User updated by: info at php-power dot it
Reported By: info at php-power dot it
-Status: Feedback
+Status: Open
Bug Type: SQLite related
Operating System: Windows XP
PHP Version: 5.0.0b1 (beta1)
New Comment:
Thanks.
When I write sqlite_seek($result, 1); I creed that sqlite_cuttent()
return the first line to a query,
but the second line is returned :|
Previous Comments:
------------------------------------------------------------------------
[2003-07-08 11:32:09] [EMAIL PROTECTED]
So is it working?
If not, can you clarify what the problem is? :)
------------------------------------------------------------------------
[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
