-----Original Message----- From: php@xxxxxxxxxxxxx [mailto:php@xxxxxxxxxxxxx] Sent: Thursday, October 27, 2011 8:00 PM To: php-db@xxxxxxxxxxxxx Subject: Simple MySQL sample code runs out of memory Running PHP 5.3.5 on FreeBSD 8.2 connecting to a MySQL 5.1.55 server. <snip> $row = mysql_fetch_array( $result ); while ($row) { ... </snip> Your while() condition will always be true, so that loop will run forever. Until you run out of memory. What you probably meant was to replace those two lines with something like this: while($row = mysql_fetch_array( $result ) ) { A new row is fetched each time the while loop goes through another iteration, until you run out of rows and the condition evaluates to false. Toby -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
