Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Simon Slavin
On 21 Oct 2011, at 12:05am, Prashant Prabhudesai wrote: > $db = new SQLiteDatabase('db/reg.s3db'); This is the old-style SQLite2 interface. I strongly suggest you switch to the new SQLite3 interface as documented here: http://www.php.net/manual/en/book.sqlite3.php In that your line would be

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Stephan Beal
On Fri, Oct 21, 2011 at 1:05 AM, Prashant Prabhudesai < prashantprabhude...@gmail.com> wrote: > $row = $res->fecth(); > ... After the script exits successfully I inspect the value in the Token column > Are you 100% sure the above command executes correctly? -- - stephan beal

[sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token