In most cases you will not need both the numeric and string keys, so you can benefit from the increased performance of just using SQLITE_ASSOC (string keys) or SQLITE_NUM (numeric keys).

<?php
    $db = sqlite_open(dirname(__FILE__)."/db.sqlite");

    $result = sqlite_query("SELECT * FROM auth_tbl LIMIT 1", $db);

    echo '<pre>';
    while (($row = sqlite_fetch_array($result, SQLITE_ASSOC))) 
        print_r($row);
    echo '</pre>';
?>
Output