On 7 Jul 2011, at 6:52am, James_21th wrote:
> $dbh = new PDO('sqlite:test.db');
> $result=$dbh->query("INSERT INTO tbl1(one,two) VALUES ('new1','new2')");
Make one application which does
DROP table IF EXISTS
CREATE the table
Do the INSERT as above
Do a SELECT for that data
For each operation you should test the $result and check to see it's SQLITE_OK.
You do not need to specify a transaction (BEGIN/COMMIT). SQLite will do it for
you.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
