The table already created with some data inside, the existing data can be display use "select * from tbl1".
----- Original Message ---- From: Michael Stephenson <domehead...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thu, 7 July, 2011 1:59:40 PM Subject: Re: [sqlite] Insert not working for sqlite3 I don't see something like a "create table tbl1(one, two);" statement. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th Sent: Thursday, July 07, 2011 1:52 AM To: General Discussion of SQLite Database Subject: [sqlite] Insert not working for sqlite3 Dear all, I'm able to connect to sqlite3 DB and display the data inside, but when insert data, no matter how to try, just don't work, there's no error, but no data inserted. Below is the simple PDO SQL I'm using, table name is "tbl1", the two fields name is just "one" & "two": $dbh = new PDO('sqlite:test.db'); $result=$dbh->query("INSERT INTO tbl1(one,two) VALUES ('new1','new2')"); Any feed back will be greately appreciated! Regards! James _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users