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]; ?>

Put those ids in an array and look at this question: https://stackoverflow.com/questions/9618277/how-to-use-php-array-with-sql-in-operator — catcon, Jul 24 '19 at 04:56

score 0 · Answer 1 · edited Jul 24 '19 at 05:21

0

You can use IN to check in a list

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

edited Jul 24 '19 at 05:21

dbrumann

answered Jul 24 '19 at 04:57

vizsatiz

1 Answers1