whats wrong with this (count sql)

[mxadam]

set rstotalcustomers = conn.execute("Select COUNT(username) as Total from users WHERE sponsor = '" & membersid & "and WHERE upgraded =1'")

[md_irfan_amu]

Use this..........
set rstotalcustomers = conn.execute("Select COUNT(username) as Total from users WHERE sponsor = '" & membersid & "' and upgraded =1'")

Let me know it works or not....

[mxadam]

will try cheers

[mxadam]

Syntax error in string in query expression 'sponsor = '' and upgraded =1''.

[Kupo?]

set rstotalcustomers = conn.execute("Select COUNT(username) as Total from users WHERE sponsor = '" & membersid & "' and upgraded =1")

You had an extra quote in there. This should work.