Yes, 100% sure, because I only have one copy on my PC, and the script which can 
display the db's data also on the same directory. 
I also tried below, but no error captured, just nothing happened.
try {
$result=$dbh->exec("INSERT INTO tbl1(one,two) VALUES ('new1','new2')");
} catch(PDOExecption $e) {
print "Error!: " . $e->getMessage() . "</br>";

----- Original Message ----
From: Stephan Beal <>
To: General Discussion of SQLite Database <>
Sent: Thu, 7 July, 2011 2:27:34 PM
Subject: Re: [sqlite] Insert not working for sqlite3

On Thu, Jul 7, 2011 at 8:24 AM, James_21th <> wrote:

> The table already created with some data inside, the existing data can be
> display use "select * from tbl1".

Are you 100% sure that the test.db being opened here is the same test.db
being used in the rest of he code (same directory)?

----- stephan beal
sqlite-users mailing list
sqlite-users mailing list

Reply via email to