[PHP-DB] Dealing with One-to-Many SELECTS (MySQL)

2002-02-04 Thread hz11
Hello, I have three tables: CREATE TABLE event ( eid int(10) unsigned NOT NULL auto_increment, tid smallint(5) unsigned NOT NULL default '0', itimestamp int(10) unsigned NOT NULL default '0', etimestamp int(10) unsigned NOT NULL default '0', somethingelse tinyint(4) NOT NULL default '

[PHP-DB] Poisoned Persistent OCI8 Connections

2002-02-02 Thread hz11
I have PHP 4.0.6 compiled as an Apache 1.3.20 module with OCI8 and MySQL on RedHat 6.2. I use persistent connections with OCI8 to avoid the costly connection construction for Oracle for each request. However, I notice that these persistent connections get "poisoned" under certain circumstances.