RE: [PHP-DB] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai (pprabhud)
-Original Message- > From: n.a.mor...@brighton.ac.uk [mailto:n.a.mor...@brighton.ac.uk] > Sent: Friday, October 21, 2011 2:33 AM > To: Prashant Prabhudesai (pprabhud); php-db@lists.php.net > Subject: RE: [PHP-DB] PHP + SQLite - Issues with update > > Try using the query: >

RE: [PHP-DB] PHP + SQLite - Issues with update

2011-10-21 Thread N . A . Morgan
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:pprab...@cisco.com]