Hello,
I would want to make a question over the function sqlite_seek(), why it is
giving to me of the problems.
When I make a query with sqlite_query() and use sqlite_fetch_array() all
works well:
Example:
$result = sqlite_query('SELECT * FROM test', $conn);
while($row = sqlite_fetch_array($resulr, SQLITE_NUM, true)){
$rows[] = $row;
}
$rows is:
Array
(
[0] => Array
(
[0] => 1
[1] => toro
[2] => 10
[3] => 500.00
)
[1] => Array
(
[0] => 2
[1] => gallo
[2] => 5
[3] => 200.00
)
[2] => Array
(
[0] => 3
[1] => rana
[2] => 20
[3] => 100.00
)
[3] => Array
(
[0] => 4
[1] => cane
[2] => 3
[3] => 500.00
)
)
if I use sqlite_seek() and sqlite_current:if(sqlite_seek($this->result,
1)){ $row = sqlite_current($this->result, $this->type, true);}$row is:
Array
(
[0] => 2
[1] => gallo
[2] => 5
[3] => 200.00
)in place of the first record return the second (The row number is
one-based (1 is the first row) in sqlite_seek()).using sqlite_rewrite() and
sqlite_current() I obtain the first record, but it is not possible to
obtainthe first record of a rowset with sqlite_seek() and sqlite_current()?I
am writing a pretty class for SQLite, this is the last problem that I have
before the release :)but I do not find other documentation for sqlite and
PHP.ThankAlan D'Angelo
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
