Is it possible to have a "subtract 1" type command for credits in this mysql query...
UPDATE members SET CREDITS='$reduced' WHERE ID='$member'
I want to update the credits by subtracting 1 from the row's credit's value, I just want to use one line instead of having one line like this...
SELECT CREDITS FROM members WHERE ID='$member'
and then having php do credits minus one as the "$reduced" variable's value
and then running this query
UPDATE members SET CREDITS='$reduced' WHERE ID='$member'
There has to be a way to just update a row in the members table that will subtract 1 from the current value of credits in the row... hopefully I didn't lose anyone 🙂
