<?php
    $database = sqlite_open('base');
    $query = sqlite_query($db, "CREATE TABLE IF NOT EXISTS 'Settings'
    (
        'ID' INTEGER PRIMARY KEY,
        'INDEX' VARCHAR(32),
        'TITLE' VARCHAR(32)
        'VERSION' FLOAT
    )");
    $query = sqlite_query($db, "INSERT INTO 'Settings' VALUES
    (
        NULL,
        'Infinity-Gaming.net',
        'Indeks',
        '1.0.0.0'
    )");
    $query = sqlite_query($db, "SELECT 'INDEX', 'TITLE', 'VERSION' FROM 'Settings' WHERE 'ID' = '0'");

    while($data = sqlite_fetch_array($query, SQLITE_ASSOC))
    {
        echo 'Indeks: "
                .$data["INDEX"].
            "<br/>Tytuł: "
                .$data["TITLE"].
            "<br/>Wersja: "
                .$data["VERSION"]"
            ';
    }
    echo "Znaleziono " .sqlite_num_rows($query). "wpisów.";
?>