I have table it's name Members contain this field (ID,username,Number)
How can I go to the recode that it's ID=4 and add 1 to Number
Printable View
I have table it's name Members contain this field (ID,username,Number)
How can I go to the recode that it's ID=4 and add 1 to Number
if you are adding members in, and want to increment the id everytime you add one, just set the 'id' field to auto incrementPHP Code:$sql = "UPDATE members SET id = id + 1 WHERE id = '4'";