SQLite3::query
SQLite3::version
SQLite3
PHP Manual

# SQLite3::querySingle

(No version information available, might be only in CVS)

SQLite3::querySingle — Executes a query and returns a single result

### Description

public mixed SQLite3::querySingle ( string `$query` [, bool `$entire_row` ] )

Executes a query and returns a single result.

### Parameters

`query`

  The SQL query to execute.

`entire_row`

  By default, querySingle returns the value of the first column returned by the query. If entire_row is `TRUE`, then it returns an array of the entire first row.

### Return Values

Returns the value of the first column of results or an array of the entire first row (if entire_row is `TRUE`), otherwise `FALSE` on failure.

### Examples

Example #1 SQLite3::querySingle() example

`<?php
$db = new SQLite3('mysqlitedb.db');
var_dump($db->querySingle('SELECT username FROM user WHERE userid=1'));
print_r($db->querySingle('SELECT username, email FROM user WHERE userid=1', true));
?>`

The above example will output something similar to:

    string(5) "Scott"
    Array
    (
        [username] => Scott
        [email] => scott@example.com
    )

SQLite3::query
SQLite3::version
SQLite3
PHP Manual