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.
updating multiple rows at the same time
Moderator: General Moderators
Well it would not be updating the same exact same data to every row, that is simple enough. Example, I only want to update values within a field called "rank". however each row will have a different value for the "rank" field. I suppose there is no way around it especially if I have to first match the user id to his/her individual ranking.