如果呢句update想轉做php寫法應該點寫?

以下呢段code點轉做php的寫法?
update stock set qty = stock.qty - shopping.qty
from stock, shopping
where stock.name = shopping.name
and shopping.sid = '$sid'