uk1900
asked on
how can I update 1000s of rows?
hi experts,
using the function update1 I am trying to do the following:
start with: $limit1 =0;
use: update1($limit1);
echo $mymessage;
refresh the page ...
$limit1 +=50;
use: update1($limit1);
echo $mymessage;
refresh again until $limit1 > mysql_num_rows($query).
regards,
using the function update1 I am trying to do the following:
start with: $limit1 =0;
use: update1($limit1);
echo $mymessage;
refresh the page ...
$limit1 +=50;
use: update1($limit1);
echo $mymessage;
refresh again until $limit1 > mysql_num_rows($query).
regards,
update1($limit1) {
.....
mysql_query("UPDATE ... WHERE .... ORDER BY id LIMIT $limit1,50");
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In other words, the value to update in the first 50 rows, is not the same in the next 50 rows &.
That's why I need to repeat this while $limit1 < $max:
--------------------------
refresh the page ...
$limit1 +=50;
use: update1($limit1);
echo $mymessage;
--------------------------
Q: how can I refresh the page and echo a message each time?