Re: [PHP-DB] connection id mystery

2007-07-26 Thread Stut
Charles Whitaker wrote: Using persistant connections simply means that you will be given a connection from a pool of open connections rather than creating a new one each time. There is no guarantee you'll get the same connection from request to request. Right. I had assumed that I would get

Re: [PHP-DB] connection id mystery

2007-07-25 Thread Stut
Charles Whitaker wrote: Since I'm requesting persistent connections, why don't I get the same connection each time? Or, to ask it another way: I notice that the number of threads slowly increases as I continue to access records -- why would this happen if I'm using persistent connections? I

[PHP-DB] connection id mystery

2007-07-25 Thread Charles Whitaker
Greetings, I'm developing a tech support log using php and MySQL. Users will add, delete and modify records. In fact, it's fully implemented except for concurrency control. I'm trying to use get_lock and release_lock to implement record-level locking, but when I go to release the lock, the