How to perform multiple records updates in PHP?
Jan 28th, 2007 22:53
Narendra Jain, ckb k,
e.g. If you want to update product weight for all unshipped orders,
you can have a query as below to update multiple records:
set weight = 11.55
where product_id = "$required_product_id"
and ship_status = "open"
It depends on the database you are using, which will give you total
number of records which will get updated using this query - a good way
to display after the update is complete.