sqlite COUNT

[JeViCo]

Hello everyone! Maybe i'm in wrong section but still it related to scripting i guess 

Could you check me please?

dbPoll(dbQuery(db, "SELECT COUNT(Account) FROM AllAccTable WHERE acc = ?", toJSON(getAccountName( acc ))), -1)

I want to count rows in table AllAccTable in Account column where acc matches with current player's account name (for example i want to get all rows with certain player from 9999 rows)

[Dimos7]

dbPoll(dbQuery(db, "SELECT COUNT(Account ) * FROM AllAccTable WHERE acc=?", toJSON(getAccountName(acc))), - 1)

 

Edited April 24, 2018 by Dimos7

[JeViCo]

adding * creates an error.

dbPoll(dbQuery(db, "SELECT COUNT(Account) FROM AllAccTable WHERE acc = ?", toJSON(getAccountName( acc ))), -1)

My code returns number 1 even when the database is empty/ Help!

[JeViCo]

bump

[idarrr]

That query should work and return zero as column COUNT(Account)

Should be like this

result[1]["COUNT(Account)"]