updating multiple rows at the same time
Posted: Mon Aug 30, 2004 7:36 pm
quick question.
is there a way to store variables in an array then update multiple rows at the same time. Here's the situation. I have a series of user who's ranking order I want to change. Now instea of looping through every users id and on each count performing an "update" call. is there a way to store new variables into an array than just pass the array to mysql to update.
I ask because I am sure that with growing sets of data, making an individual call to "update" for each user will slow down the connection. especially when there will be over 1000 users.
best,
Edward M.
is there a way to store variables in an array then update multiple rows at the same time. Here's the situation. I have a series of user who's ranking order I want to change. Now instea of looping through every users id and on each count performing an "update" call. is there a way to store new variables into an array than just pass the array to mysql to update.
I ask because I am sure that with growing sets of data, making an individual call to "update" for each user will slow down the connection. especially when there will be over 1000 users.
best,
Edward M.