Add 1 to TimesLoggedIn field after use logs in

[anton_1]

what is the best way to add 1 to the database filed TimesLoggedIn after a user has logged in?

 

 

Regards

 

Ant

 

 

[dragon_sa]

Pull the current value out of the database when you check the username and password, if they are successful at logging in, add 1 to it and update that field in the database

[Jessica]

you don't even need to select that value, you can increment a value by using the column name. After they have successfully logged in,

UPDATE `loggedInTimes` = `loggedInTimes`+1 WHERE userID = x

[Drummin]

you don't even need to select that value, you can increment a value by using the column name. After they have successfully logged in,

UPDATE `loggedInTimes` = `loggedInTimes`+1 WHERE userID = x

I didn't know you could do that.  That's cool.