holding a loop

agmorgan

Can sombody give me a pointer in the right direction.

I am using a loop

while ($row = mysql_fetch_array($result))
{
extract($row);

echo "<table >
<td>$createDate</td>\n
<td>$loginName</td>\n

</td>\n
</tr>\n</table>";

}

What I want to do is loop this 10 times echoing the first 10, and then pause. Then on the click (or something) the next 10 come up on the screen.

My thinking is that I need to use the continue function to restrict the loop, but how do I just pause it, instruct it to restart but on a clean screen..

dalecosp

Strictly using PHP, there's not a way I can think of to "pause". Each script exists only during execution time. You could, I suppose, write all results to an array in memory ($_SESSION, perhaps?), but that might be a performance hit in a big app. You might even write the whole result set to output, but submit the excess data in "Hidden" html fields to POST to the next page. You could even....

It might be preferable to use your SQL (or PHP's mysql_num_rows()?) to get the number of returned rows from the db, then run the queries again on each page load, using SQL LIMIT statements.

trexx

it's something you could do with javascript. write a javascript function, that gets called when the html document has loaded, then waits 10 secs. and then reload the page while increasing a parameter. that could look like this...

...
<script>
function start() {
   // set a timeout here that calls "reload" after 10 secs.
}

function reload() {
    document.location = "<?=$_SERVER['PHP_SELF']?>?count=<?=intval($_GET['count'])+1?>";
}
</script>
<body onLoad="start()">
<?php
 $q =  'select * from xyz limit ' . (intval($_GET[count]) * 10) . ', 10';
...
?>
</body>
....

It's just some kind of paging...