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

2011-10-21 Thread Prashant Prabhudesai (pprabhud)
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 Messag

Re: [PHP-DB] SELECT

2011-10-21 Thread tamouse mailing lists
On Fri, Oct 21, 2011 at 2:09 AM, Ford, Mike wrote: >> -Original Message- >> From: tamouse mailing lists [mailto:tamouse.li...@gmail.com] >> Sent: 20 October 2011 21:37 >> >> On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike >> wrote: >> >> -Original Message- >> >> From: Ron Piggott [mai

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]

RE: [PHP-DB] SELECT

2011-10-21 Thread Ford, Mike
> -Original Message- > From: tamouse mailing lists [mailto:tamouse.li...@gmail.com] > Sent: 20 October 2011 21:37 > > On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike > wrote: > >> -Original Message- > >> From: Ron Piggott [mailto:ron.pigg...@actsministries.org] > >> Sent: 17 October 2