<div>
thanks for the confirmation
</div>


<div>
Actually, that isn't true. &nbsp;That method gets all the data from MySQL at once and puts it into an array of arrays. &nbsp;It's not just 'copying' it. &nbsp;Then the 'foreach' is used to go thru the results to do what you want.<br />
<br />
The functions of getting the data from the database and generating the display for the page are broken into two separate sections this way. &nbsp;It also clears all the data from the database query so you can reuse that query. &nbsp;Until all the data is retrieved, you can't 're-use' that query, you would have to make a new one.<br />
<br />
This is even more useful when you have more than one database array to deal with. &nbsp;I have pages that get three different arrays from the database that are then used for different sections of the page. &nbsp;The second and third arrays are dependent on content from the first one.
</div>


<div>
Well if you are sticking with the old mysql library it would be easier to just use <a href="http://php.net/mysql_fetch_array" rel="ugc">fetch_array</a><br />
But the answer was based on the posted code<br />
(or better still move to PDO)
</div>


<div>
I've moved everything to 'mysqli'. &nbsp;It has nothing really to do with the particular library but the method that is being used. &nbsp;I use it a lot for the reasons I stated.
</div>


<div>
<div class="content wysiwyg-content">
I have an inherited script that has the loop:<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<pre><code class="code-1 nolinks" id="code-10-28565734-1"><span>while($row = mysql_fetch_array($result)) {</span>
<span>		$result_array[] = $row;</span>
<span>	}</span>
<span>         foreach ($result_array as $result) {</span>
<span>        ... }</span>
</code></pre>
<br />
what is the benefit of splitting this seemingly common/conventional (mysql results) loop into two loops?<br />
and doesn't the first loop just copy the array, row by row?
</div>
</div>


I have an inherited script that has the loop:

	(CODE)

what is the benefit of splitting this seemingly common/conventional (mysql results) loop into two loops?
and doesn't the first loop just copy the array, row by row?

PHP array question

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.