How to update multiple MySQL table entries with different id?

by

You can use IN to check in a list

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

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. Php charset information [duplicate]
  3. How can I prevent SQL injection in PHP?
  4. jQuery Validate remote method usage to check if username already exists
  5. PDO get the last ID inserted
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. MySQLi prepared statements error reporting [duplicate]
  8. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  9. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  10. How do I import a .sql file in mysql database using PHP?
  11. PHP Fatal error: Class ‘PDO’ not found
  12. Connect to a MySQL server over SSH in PHP
  13. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  14. PHP Warning: mysqli_connect(): (HY000/2002): Connection refused
  15. MYSQL Select from tables based on multiple rows
  16. Is “SET CHARACTER SET utf8” necessary?
  17. Sending HTML Code Through JSON
  18. Do I really need to do mysql_close()
  19. convert date string to mysql datetime field
  20. Turn off warnings and errors on PHP and MySQL
  21. Stored Procedures, MySQL and PHP
  22. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  23. MySQL/SQL retrieve first 40 characters of a text field?
  24. How to use mysqli_query() in PHP?
  25. Get sum from nodes tree
  26. PHP/SQL Insert Error when using Named Placeholders
  27. How to specify the parent query field from within a subquery in MySQL?
  28. CONCAT columns with Laravel 5 eloquent
  29. array_push() vs. $array[] = …. Which is fastest? [duplicate]
  30. How to upload image PHP and insert path in MySQL?

Leave a Comment