php - How to update multiple MySQL table entries with different id?

Question

Please make simple answer :)

<?php UPDATE user SET point='$_POST[point]' WHERE id='$_POST[id]; ?>

This is image of my simple design

标签： phpmysql

Answer 1

您可以使用IN签入列表

UPDATE user SET point='$_POST[point]' WHERE id in (<list of ids>);