[sqlite] Insert not working for sqlite3

[James_21th]

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