How do I post +1 to a number in a SQL database?

Get help using Construct 2

Post » Sat Jun 27, 2015 4:00 pm

I want to know how often people play my game. On Start Layout, is there a way to send +1 to an SQL database? I already understand the concept of posting top 10 highscores to SQL. I just want to know how to keep adding 1 to a specific number hosted in SQL.
Check out my games on Google Play:
BEAST ATTACK (1,000,000+ downloads!)
ZOMBIE BASH (Android) (Launched Feb 17)
ZOMBIE BASH (iOS) (Launched March 17)
B
56
S
18
G
2
Posts: 438
Reputation: 5,636

Post » Sun Jun 28, 2015 9:29 am

update `table` set counter = counter + 1 where id = 1


Thats a bit of sql right there, assuming you have a table called "table" and that it has at least 2 columns, id and counter, and a record with id of 1.
Who dares wins
B
57
S
17
G
21
Posts: 1,878
Reputation: 19,572


Return to How do I....?

Who is online

Users browsing this forum: farsen, Kyu and 40 guests