Do you know how to do that storedvalue.dbs the file to appear on the site show data Cash, Dist and Health?
<?php
php
$dbhandle = sqlite_open('db/test.db', 0666, $error);
if (!$dbhandle) die ($error);
$query = "SELECT Name, Sex FROM Friends";
$result = sqlite_query($dbhandle, $query);
if (!$result) die("Cannot execute query.");
$row = sqlite_fetch_array($result, SQLITE_ASSOC);
print_r($row);
echo "<br>";
sqlite_rewind($result);
$row = sqlite_fetch_array($result, SQLITE_NUM);
print_r($row);
echo "<br>";
sqlite_rewind($result);
$row = sqlite_fetch_array($result, SQLITE_BOTH);
print_r($row);
echo "<br>";
sqlite_close($dbhandle);
?>
<?php
CREATE TABLE fi_user_value (
idUserValue INTEGER PRIMARY KEY NOT NULL DEFAULT '',
key CHAR( 50 ),
userName CHAR( 20 ),
nickName CHAR( 20 ),
nickNameStripped CHAR( 20 ),
numval INTEGER,
strval CHAR(50)
)
?>
<?php
CREATE TABLE Player (
ID INTEGER PRIMARY KEY NOT NULL DEFAULT '',
Name CHAR( 20 )
)
?>