[SOLVED] interrupt while loop, then resume?

[theredking]

Hello all, just a quick question: I have a while loop populating a table for which I've already written a header. This table ends up having quite a number of rows, and the information in the header is lost as you scroll down the table. Is there a way to interrupt the while loop, re-insert the header information and then continue the loop until it finishes?

 

Thanks all in anticipation..

[carrotcake1029]

How does it get lost?

Could you show some code of what you are doing so we can get a better understanding?

[9three]

You can use

 

break and continue

[hobeau]

I definitely need to see your code but it sounds like what your trying to do is generate the following:

 

<table>

<tr>

<th>header1</th>

<th>header2</th>

</tr>

<tr>

<td></td>

<td></td>

</tr>

... more rows and cells...

<tr>

<th></th>

<th></th>

</tr>

...so on and so forth...

</table>

 

If this is the case you would simply need to have a counting variable that starts at zero and increments each iteration of the loop ($i++). Then you would need to have an 'if' statement that would check the value of the counter and if the value is somewhere say 15, you would concatenate the table headers and reset the counter variable back to 0 ($i = 0;) and the loop would continue on adding headers every 15 rows. Of course you can change this to any number you wish, you would just need to specify this in the if statement.

[theredking]

Wow, sorry all, I didn't get any notification that there had been replies to this topic. Thank you so much, I'll take a look at this and get right back to you all. Thank you again!

[theredking]

I've cut out most of the code to just show you the loop. I'm not quite sure how to get the if statement worked into here and then reset the loop. Thanks again.

 

$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {

print "data goes here.";

$i++;
}

[premiso]

I've cut out most of the code to just show you the loop. I'm not quite sure how to get the if statement worked into here and then reset the loop. Thanks again.

 

$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {

print "data goes here.";

$i++;
}

 

$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {

if ($i = ceil($num/2)) {
     echo 'table header info here';
}
print "data goes here.";

$i++;
}

 

You do not really want to "break" or "continue", you just want to add another row halfway through the results, That should do it, and if /2 does not give it enough try /3 or /4 etc until you get it how you want.

[theredking]

Hi Premiso,

 

I just tried your suggestion, and that seems to insert the header information after every results row that is printed... Is that what it should do?

 

Thanks

[premiso]

Sorry, syntax mistake:

 

if ($i == ceil($num/2)) {

 

Replace that line above, before it had a single = it should be == for comparison.

[theredking]

That's it, thank you! Fantastic!!

[theredking]

Ok, this is almost exactly what I want it to do now, but it only re-inserts this header information once. Is there a way to tell it to insert it every 10 or twelve rows? I have tried:

 

if ($i == 10) {

 

but obviously this only inserts it after the 10th row, it doesn't do it every 10 rows. I'm going to keep trying to figure this out, but any help would be greatly appreciated.

 

Thanks

 

 

[premiso]

Ok, this is almost exactly what I want it to do now, but it only re-inserts this header information once. Is there a way to tell it to insert it every 10 or twelve rows? I have tried:

 

if ($i == 10) {

 

but obviously this only inserts it after the 10th row, it doesn't do it every 10 rows. I'm going to keep trying to figure this out, but any help would be greatly appreciated.

 

Thanks

 

 

 

if (($i%10) == 0) {

 

The modulus operator is what you want.

[theredking]

Perfect. Thank you so much for your time.