note 52586 deleted from function.mysql-query by mazzanet
| From: | mazzanet@php.net | Date: | Sun, 02 Oct 2005 13:41:16 +0000 |
| Subject: | note 52586 deleted from function.mysql-query by mazzanet | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-96183@lists.php.net to get a copy of this message | ||
Note Submitter: webmaster at demogracia dot com
----
The output of the query is cached in the MySQL server. Every time you call mysql_fetch_assoc() one
row is transmitted from MySQL server to your PHP script. That means the connection is kept open
while $resource exists. Also, if MySQL dies before you fetch all rows your script will fail.