I need the update command for taking a number variable from a form I've already got built and add it to an already existing number in the database, can someone tell me what the proper syntax for this is.
Say database is accounts, variable from the form is turns, mysql table inside accounts is acc_turns, Ive been trying to find a working example and all im getting is parse errors.
UPDATE accounts
SET acc_turns = acc_turns + $turns
WHERE ????
basically i need to know what the ???? is, the database itself we'lll call jay, table is accounts, column inside is acc_turns, i have the $turns variable already. This has absolutely drove me nuts been coding exe apps way to long and havent touch php in such a while...
Say database is accounts, variable from the form is turns, mysql table inside accounts is acc_turns, Ive been trying to find a working example and all im getting is parse errors.
UPDATE accounts
SET acc_turns = acc_turns + $turns
WHERE ????
basically i need to know what the ???? is, the database itself we'lll call jay, table is accounts, column inside is acc_turns, i have the $turns variable already. This has absolutely drove me nuts been coding exe apps way to long and havent touch php in such a while...