my database has 25000 rows. Using a While-loop i get the data.
Now i want to use SLEEP() everytime 500 rows are picked up.
I created the script below, but this script only works one time at 500 rows.
<?php
$i=0;
while($value = mysql_fetch_assoc($result)) {
if($i == 500) {
// sleep for 10 seconds
sleep(10);
}
//continue
$i++;
}
?>
How to mainupulate this script to make it work every 500 rows?
You need to replace ($i == 500) by ($i%500 == 0)
<?php
$i=0;
while($value = mysql_fetch_assoc($result)) {
if($i % 500 == 0) {
// sleep for 10 seconds
sleep(10);
}
//continue
$i++;
}
?>
check $i%500
<?php
$i=0;
while($value = mysql_fetch_assoc($result)) {
if($i%500 == 0) {
// sleep for 10 seconds
sleep(10);
}
//continue
$i++;
}
?>
Use this
while($value = mysql_fetch_assoc($result)) {
if($i % 500 == 0) {
// sleep for 10 seconds
sleep(10);
}
//continue
$i++;
}
?>
<?php
$i = 0;
while($value = mysql_fetch_assoc($result)) {
if(++$i % 500 === 0) {
// sleep for 10 seconds
sleep(10);
}
}
?>