Re: Simple MySQL sample code runs out of memory

From:	Karl DeSaulniers	Date:	Fri, 28 Oct 2011 03:43:48 +0000
Subject:	Re: Simple MySQL sample code runs out of memory
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-48070@lists.php.net to get a copy of this message

Maybe this.. HTH, <?php ... $result = mysql_query( $qry, $db_conn ) or die( mysql_error() . "\n" ); $num_rows = mysql_numrows($result); if(!$result || ($num_rows <= 0)){ echo "Error displaying info"; } else if($num_rows > 0){ for($i=0; $i<$num_rows; $i++){

      $c = mysql_result($result,$i,"contract");

      echo sprintf( "|%13d |%7d |\n", $c, $i );

} } ?> Best, Karl On Oct 27, 2011, at 6:59 PM, php@umpquanet.com wrote:

<?php require_once( '../include/mysql_funcs.php' ); $db_host = $test_db_host; $db_user = $test_db_user; $db_name = $test_db_name; $db_pwd = $test_db_pwd; if (!($db_conn = mysql_connect( $db_host, $db_user, $db_pwd )))
       die( "Can't connect to MySQL server\n" );
if (!mysql_select_db( $db_name, $db_conn ))
       die( "Can't connect to database $db_name\n" );
$qry = "select * from test_table order by contract"; if ($result = mysql_query( $qry, $db_conn )) {
       $row = mysql_fetch_array( $result );
       while ($row) {
               $c = $row[ 'contract' ];
               $n = 0;
               while ($row && ($c == $row[ 'contract' ])) {
                       $n++;
                       $row = mysql_fetch_array( $result );
               }
               echo sprintf( "|%13d |%7d |\n", $c, $n );
       } // while
} else {
       die( mysql_error() . "\n" );
} ?>

Karl DeSaulniers Design Drumm http://designdrumm.com