Is this so bad when using MySQL queries in PHP?
- by alex
I need to update a lot of rows, per a user request. It is a site with products.
I could...
Delete all old rows for that product, then loop through string building a new INSERT query. This however will lose all data if the INSERT fails.
Perform an UPDATE through each loop. This loop currently iterates over 8 items, but in the future it may get up…