Sqlite with PHP Select Query
SQLite3::query returns a result resource object. You need to use the fetchArray method on it to get rows from it:
$query = "select user FROM test";echo "here";$result = $dbname->query($query);while ($row = $result->fetchArray()) { print $row["user"] . "\n";}