Had already tried that without any success. What bugs me is that if I error the script out rather than exit it cleanly the token value shows up in the DB. It's causing me to wonder if it's some streams issue. Even if it was, I have no idea how to fix it. Thanks, Prashant. > -----Original Message----- > From: N.A.Morgan@xxxxxxxxxxxxxx [mailto:N.A.Morgan@xxxxxxxxxxxxxx] > Sent: Friday, October 21, 2011 2:33 AM > To: Prashant Prabhudesai (pprabhud); php-db@xxxxxxxxxxxxx > Subject: RE: PHP + SQLite - Issues with update > > Try using the query: > > $db->query("update SERVER set Token = '$intoken' where IPAddress ='192.168.1.100'"); > > You are trying to update all rows with $intoken, where the column Token is unique. > > Regards, > Neil Morgan > > -----Original Message----- > From: Prashant Prabhudesai [mailto:pprabhud@xxxxxxxxx] > Sent: 21 October 2011 04:04 > To: php-db@xxxxxxxxxxxxx > Subject: PHP + SQLite - Issues with update > > 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 varchar(100) unique > ); > > > INSERT INTO SERVER (IPAddress, Token) VALUES > ('192.168.1.100', ''); > > > I am trying to update the Token field using the following code - > > > [snip] > > > $db = new SQLiteDatabase('db/reg.s3db'); > > > $intoken = uniqid(); > > > $db->query("update SERVER set Token = '$intoken'"); > > > $res = $db->query("select * from SERVER"); > > > $row = $res->fecth(); > > > $outtoken = $row['Token']; > > > echo $outtoken; > > > [snip] > > > After the script exits successfully I inspect the value in the Token column > and its empty. But the echo statement in the snippet above prints the proper > value. > > > Interestingly, if I error out the script with a syntax error or some such > after the update but before it exits, the value shows up in the Token > column. > > > Any idea what is happening here and I need to do here. Seems like there is > some sort of flush that needs to happen which happens only if the script > errors out. > > > Any help is appreciated. > > > Thanks, > Prashant. > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > ___________________________________________________________ > This email has been scanned by MessageLabs' Email Security > System on behalf of the University of Brighton. > For more information see http://www.brighton.ac.uk/is/spam/ > ___________________________________________________________ > > ___________________________________________________________ > This email has been scanned by MessageLabs' Email Security > System on behalf of the University of Brighton. > For more information see http://www.brighton.ac.uk/is/spam/ > ___________________________________________________________ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
