*: CREATE A NEW TABLE IN A .db FILE:

<pre>
$dbfile = 'foo.db';
if (!$db = sqlite_open($dbfile, 0666, $err) ) { die($err); }
$create='CREATE TABLE CONTACTS(
name VARCHAR(32),
precall VARCHAR(5),
number VARCHAR(30)
)';
$sql = sqlite_query($db,$create);

sqlite_query($db, " INSERT INTO CONTACTS
VALUES ('PETER','089','4711')");
sqlite_query($db, " INSERT INTO CONTACTS
VALUES ('ANNA','040','1122')");
sqlite_query($db, " INSERT INTO CONTACTS
VALUES ('Maxi','089','9876')");
sqlite_close($db);
</pre>
------------------------------------------