hi mate, is there a best way to update a thousand of records in one click? right now the way i do it makes the server run away error, due to the loop i used if you can provide an example, it would be great. what i want is if i click on update button, it will update each row one by one, so there should also be a progress bar, but that i can do myself,. how can i utilize loop such as foreach,.. for,.. to do thousand of updating... Any help is highly appreciated. Cheers!
what do you mean, can you give an example? i need to be able to, lets say update one record at a time using foreach or any loop that will not cause mysql server lag, due to heavy load of update loops Thank you
Your head is in the wrong place. Forget about code. Mysql does not require code to run queries. You can run them from the command line or use free GUI's like Phpmyadmin. There is no need for code at all.