flush() counter in mysql while loop

kidgeek_dfw

I have a counter that works like this... <see code below>

When I try the same script in a while loop, instead of a for loop, the whole page has to reload. So the result is you don't see the counter going up in the while loop like you do in the for loop...

Is there a way to make this work in a mysql while loop?

------- START CODE ------------------

<body>
<input name="sent" type="text" id="sent" value="0">
<?

for($i = 0; $i <= 10000; $i++){
echo "<script>this.sent.value='$i'</script>\n";

flush();
} // for
?>
</body>
</html>

lazzerous

While actually seeing your while loop would be a huge help (hint hint), I'm gonna throw an idea out...

Are you creating var $i and populating it within the while loop?

The following code worked for me.

<html>
<body>
<form name='theform'>
<input type='text' name='sent' value='0'>
</form>
<?
flush();

$i=0;
while ($i<1000){
    $i++;
    echo "<script language='javaScript'>theform.sent.value='" . $i . "'</script>\n";
    flush();
}
?>
</body>
</html>

kidgeek_dfw

yes but where I'm stuck is bring back my data out of mysql.
Maybe I needed to be a little bit more clear...

this kind of while loop...

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

}

I'm thinking that I'll have to write some kind of function to handle this.

As rows are returned from mysql the counter goes up in realtime.

Thanks for the response...

onion2k

Originally posted by kidgeek_dfw
while ($row = mysql_fetch_array($result)) {

}

for ($x=0;$x<mysql_num_rows($result);$x++) {
$row = mysql_fetch_array($result);
//Do stuff
}

That do ya?

PHPMagician

I think this may be the basic jist of what you are trying to achieve, though I haven't fully understood the problem at hand.

$i=0;
while ($row = mysql_fetch_array($result)) {
    $i++;
}