SQL Logic Error or missing database

[adhakal]

Hi all,

So this is the deal.

I am running some php pages on a sqlite database. The folder where all the php files reside and the database both have been chmod'ed to 666. I can get the php to read(select) off of the database, but whenever I try writing(insert) to the database using sqlite_query() it says:

SQL logic error or missing database

I am a newbee with php and sqlite. Your help will be greatly appreciated.

 

[DRJ478]

Let's see the query string, that will help us to help you.

 

[adhakal]

Heres the query

sqlite_query("insert into table1 values ('$_POST[value1]','$_POST[value2]'", $link) or fail();

function fail ( )
{
die("Query failed: " . sqlite_error_string(sqlite_last_error($link)));
}

 

[chessbot]

You are missing a closing parenthese:

sqlite_query("insert into table1 values ('$_POST[value1]','$_POST[value2]'[red])[/red]", $link) or fail();

--Chessbot

There is a level of Hell reserved for probability theorists in which every monkey that types on a typewriter produces a Shakespearean sonnet.