Why is that? So is there any other way how I coud create a highscore and update the points of every user who answered correctly? I can't update by one if there are for example 100 users who answered correctly and 100 who didn't.
Search found 3 matches
- Thu May 08, 2014 9:30 pm
- Forum: Issues
- Topic: Update columns in database
- Replies: 5
- Views: 1373
- Jump to post
- Thu May 08, 2014 5:31 pm
- Forum: Issues
- Topic: Update columns in database
- Replies: 5
- Views: 1373
- Jump to post
Update columns in database
Thanks for your quick reply! Basically I want to update points of users who answered a question correctly. 1.But I cannot update columns of several rows with a 'where' parameter (for example all users who's favorite color is blue get 10 points). What default value do I have to type in the Database S...
- Wed May 07, 2014 9:06 pm
- Forum: Issues
- Topic: Update columns in database
- Replies: 5
- Views: 1373
- Jump to post
Update columns in database
How can I update columns of some registered users (for example all users who's favorite color is blue get 10 points) in the database? In SQL I would use an UPDATE statement (UPDATE users SET user_points = 10 WHERE favorite_color = blue)