I need to write some code to update about 700 entries, same table and only 1 feild. The only way I know how to do this is to select all the entries and loop through them while running an update query inside to update each one, 1 at a time.
Is there anyway to update multiple rows at the same time if all I am doing is changing a row by multipling it by a static number?
The feilds are the cost of an item and with rising cost or parts and labor each year my clients want to be able to change the prices by a % for every item. Is there a quick way of doing that without having to loop through each one and run a seperate update query or am I stuck with doing it that way?
Thanks, Danny.
