[Vince]

Completely unnecessary since you have COUNT(*).

PHP код:

SELECT COUNT(*) AS TotalAccounts FROM playerdata 


Will output something like

TotalAccounts

42

For further reference, to increment a field:

PHP код:

UPDATE table SET field = field + 1 WHERE condition = true