How do i increment data submition by 1

Hi i want to create a data submission status and store the status in status table, example: if a user submits a data the status will be 1 and it will be stored in status column, if the user submits any other record the status will increment by one and the status in table will update to 2. Please how do i achieve this?.