sqlite_field_name

(PHP 5)

sqlite_field_name -- Returns the name of a particular field

Description

string sqlite_field_name ( resource result, int field_index)

Given the ordinal column number, field_index, returns the name of that field in the result handle result.

#DD0000">'mysqlitedb', 0666, $sqliteerror)) {

    
$sql = "SELECT id FROM sometable WHERE id = 42";
    
$res = sqlite_query($dbhandle, $sql);

    if (
sqlite_num_rows($res) > 0) {
        echo
sqlite_fetch_single($res); // 42
    
}
    
    
sqlite_close($dbhandle);
}
?>