Christian Mattar <[EMAIL PROTECTED]> wrote:
I've been having trouble with SQLite in PHP. Basically I want to
iterate over all table of a database. I use the following query:
$handle = sqlite_open("db.sqlite");
$result = sqlite_query($handle, "SELECT name FROM sqlite_master WHERE
type='table' ORDER BY name");
$tables = sqlite_fetch_array($result);
var_dump($tables);
Unfortunately, it only returns the first table name in the result.
http://www.phpbuilder.com/manual/en/function.sqlite-fetch-array.php
"Fetches the next row from the given result handle. If there are no more
rows, returns FALSE, otherwise returns an associative array representing
the row data."
You need to call it repeatedly to retrieve all the rows.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
