|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24540 sqlite_seek()
Submitted: 2003-07-08 10:56 UTC Modified: 2003-07-08 18:43 UTC
Avg. Score:4.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: info at php-power dot it Assigned: helly (profile)
Status: Closed Package: SQLite related
PHP Version: 5.0.0-dev OS:
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
49 + 6 = ?
Subscribe to this entry?

 [2003-07-08 10:56 UTC] info at php-power dot it
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.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-07-08 11:16 UTC] info at php-power dot it
sqlite_seek() moves the pointer ahead to record requested


$sqlite_seek($result, 1);

result: 2 row of table

$sqlite_seek($result, 3);

result: 3 row of table

etc ...
 [2003-07-08 11:20 UTC] info at php-power dot it
I'm tired, naturally sqlite_seek() does not have the sign $

 [2003-07-08 11:32 UTC]
So is it working?
If not, can you clarify what the problem is? :)

 [2003-07-08 11:45 UTC] info at php-power dot it

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 :|
 [2003-07-08 11:52 UTC] info at php-power dot it
they are 9 hours that I program :)
the example is:


sqlite_seek($result, 1);

return the row 2 of previous query

sqlite_seek($result, 3);

return the row 4 of previous query

etc ...

(this is the definitive example:P)
 [2003-07-08 13:59 UTC]
This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at
In case this was a documentation problem, the fix will show up soon at

In case this was a website problem, the change will show
up on the site and on the mirror sites in short time.
Thank you for the report, and for helping us make PHP better.

 [2003-07-08 16:11 UTC] info at php-power dot it
Thanks to you for the great language.

I have noticed the bug why I am writing an SQLite class :)

I have asked aid in the mailing lists, but nobody has answered (the extension is too much recent??) :)

However thanks, in my class served me the functionality of sqlite_seek() hehehe

I am studying also English ^_^
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon May 20 06:01:34 2024 UTC