Re: mysql connect, while and close big problem

http://www.php.net/manual/en/function.mysql-pconnect.php http://www.php.net/manual/en/function.mysql-connect.php I am not sure if there are any performance difference between the two. I've read in MySQL's manual that non-persistent can max out the server, thus, recommending using persistent connections. -- William Fong - wfong@mookandblanchard.com Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732 | Wireless E-mail: 8054907732@mobile.att.net ----- Original Message ----- From: "Killer Angel Clark" <ck3380@sinaman.com> To: <php-db@lists.php.net> Sent: Friday, February 22, 2002 11:03 AM Subject: Re: [PHP-DB] mysql connect, while and close big problem : non-persistent. : I would also like to ask the difference between persistent and : non-persistene connection? : : "Ray Hunter" <rhunter@enterasys.com> ¼¶¼g©ó¶l¥ó : news:59358A738F45D51186A30008C74CE250E813FF@slc-exc1.ctron.com... : > What type of connections are you making persistent or non-persistent? : > : > Ray Hunter : > Firmware Engineer : > : > ENTERASYS NETWORKS : > : > : > -----Original Message----- : > From: Killer Angel Clark [mailto:ck3380@sinaman.com] : > Sent: Thursday, February 21, 2002 10:17 AM : > To: php-db@lists.php.net : > Subject: [PHP-DB] mysql connect, while and close big problem : > : > : > I make a connection A to get an array of result. : > Then use a while loop to use the array. : > In the while loop, I use the data to select other data by making a new : > connection. After printing the data, I close this new connection. After : the : > while loop, I close the first connection too. : > : > If only have the first connection, it has no problem. : > But with the select in the while loop and close the new connection, it has : > an error on closing. Does anyone know why and how to fix it?? : > : > : > : > -- : > PHP Database Mailing List (http://www.php.net/) : > To unsubscribe, visit: http://www.php.net/unsub.php : > : : : : -- : PHP Database Mailing List (http://www.php.net/) : To unsubscribe, visit: http://www.php.net/unsub.php :