The table already created with some data inside, the existing data can be display use "select * from tbl1".
----- Original Message ---- From: Michael Stephenson <[email protected]> To: General Discussion of SQLite Database <[email protected]> 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: [email protected] [mailto:[email protected]] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
