<div>
$result = mysql_query($query);<br />
echo mysql_error();<br />
&nbsp;while($row = mysql_fetch_array($result)<wbr />){<br />
&nbsp; &nbsp; &nbsp; &nbsp; $search = $row[0];<br />
&nbsp; &nbsp; &nbsp; &nbsp; echo $search;<br />
&nbsp; &nbsp; &nbsp; &nbsp; sleep(15);<br />
}
</div>


$result = mysql_query($query);
echo mysql_error();
 while($row = mysql_fetch_array($result)){
        $search = $row[0];
        echo $search;
        sleep(15);
}

<div>
This does work, when it's finish with the whole query it displays. <br />
<br />
What are the concequences of running this against a few thousand records?
</div>


This does work, when it's finish with the whole query it displays.

What are the concequences of running this against a few thousand records?

<div>
<div class="content wysiwyg-content">
$result = mysql_query($query);<br />
echo mysql_error();<br />
&nbsp;while($row = mysql_fetch_array($result)<wbr />){<br />
&nbsp; &nbsp; &nbsp; &nbsp; $search = $row[0];<br />
&nbsp; &nbsp; &nbsp; &nbsp; echo $search;<br />
<br />
I have this. &nbsp;The final result will be different but I will be able to illustrate my question. &nbsp; I want to loop the results one by one, one every 15 second and then the next row. &nbsp;What would be the best way to do this? &nbsp;For the end result I'll strictly be doing stuff that doesn't display on the screen but I'm not sure what the consequences are of running a loop with potentially thousands of records in a database.<br />
<br />
.. Is it even possible to add timing to a php while loop.. 
</div>
</div>


$result = mysql_query($query);
echo mysql_error();
 while($row = mysql_fetch_array($result)){
        $search = $row[0];
        echo $search;

I have this.  The final result will be different but I will be able to illustrate my question.   I want to loop the results one by one, one every 15 second and then the next row.  What would be the best way to do this?  For the end result I'll strictly be doing stuff that doesn't display on the screen but I'm not sure what the consequences are of running a loop with potentially thousands of records in a database.

.. Is it even possible to add timing to a php while loop.. 

Timing on a loop..

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.