The real power of iterators comes through the ability to use foreach() for an extremely fast data retrieval from objects.

<pre>
<?php
$db = new sqlite_db(dirname(__FILE__)."/db.sqlite");

foreach($db->query("SELECT * FROM auth_tbl", SQLITE_NUM) as $row) {
    print_r($row);
}
?>
</pre>
Output