Hi All.

I have a field called "logincount". I cant figure out the query for mySQL to run to simply update the current number in that field to add "1" to it.

So for example, if the last login was 34, I need it to change to 35 when logged in.
Here is my current query:

sql= "update customerlogin Set logincount = logincount +1" & logincount &"' WHERE email='" & email &"' "

I GET SYNTAX ERRORS.

Yes it is incorrect. Change it to follow:

sql= "update customerlogin Set logincount = logincount + 1 " & "WHERE email='" & email &"'"

Thank you! worked perfectly. I see what I did now. Thank you ever so much.

You are welcome.