Entry

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:
update open_orders
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.