SQLite also offers a highly optimized method of retrieving single column data.

<?php
    $db = sqlite_open(dirname(__FILE__)."/db.sqlite");
    $res = sqlite_query("SELECT login FROM auth_tbl", $db);

    /* fetch the column as a string */
    while (($login = sqlite_fetch_single($res))) {
        echo $login . "<br />\n";
    }

    sqlite_close($db);
?>
Output