Control a "while..." loop

[Anon]

Which command allows one to stop a running while loop

while ($myrow=mysql_fetch_row($result) {...}

and continues it on a click (from the point it stops), e.g.

<A Href=...>Continue Loop</A> ?????

Thanks

[brandonschnell]

html is client side, php is server side.

to have html on the client side change the flow of a php script the page would need to be refreshed and a variable sent telling php what to do.

[roel_v]

You can jump out of a loop with 'break'. You'd have to keep a counter in the while loop, and store how far you got (either in a session of passing it in a hidden variable). Then in a next page, loop until you are from where you want to continue, or do some sql magic to start from there.
But I have to note that I'm not sure what it is you want. Like Brandon posted, this is not real-time; php is serverside so you cannot have a loop running and stop on the moment a users clicks on a link. You can only break on a condition, show a page, and put a link there to continue.
Please write clearly what it is you're trying to do.

[Anon]

Sorry for the unclear text !

Its like you wrote. In a loop I read out name, adress... from a database and give them out on a page. What I want to do is, after the loop gave out e.g. 10 results, stop it automaticely (not by the user !) show a text :

   -continue-

When now the user presses this link, the loop should continue.

It-s not a problem to construct an index counting how many results were shown. In my case, after the 10th result the link -ontinue- will be printed. But I don-t know, how to stop the loop and what I have to write at href to continue it.

while ($myrow=mysql_fetch_row($result)){
echo $name;
echo $adress;
:
:
$x=$x+1;
If ($x=="10"){
echo "<A HREF=????? onclick=?????>-Continue-</A>";
}
};

[roel_v]

Okay, you basically want previous/next links. What I have always found easiest to do is not stopping your while loop, but making sure that your sql query only returns the results you actually want to display (this is more performant, too). You can do this several ways: you're using mysql, so you could do 'SELECT foo FROM bar LIMIT 50, 10', or craft a WHERE clause: 'SELECT foo FROM bar WHERE id > 50 AND id < 60'. Another way would be 'SELECT foo FROM bar WHERE date > current_date LIMIT 25'. Read the mysql docs or an sql book if this confuses you.
Now, you can store how many results you want to show, and from which result on you are showing at the moment, in hidden variables or in your session. I personally think a session is cleaner, and harder for users to muck around with, but it's up to you. So you'd need a way to pass to every page that you want to show results on: from where in the result set they should start, and how many to show. You select from your database depending on that.
Ofcourse it gets more complicated if you want to sort on different, user definable rows and goodies like that...