how do i reset the auto increment? at present it enter users with numbers 5 and over . I deleted ones i created to test (ie users 2 to 4). How do i make the id fill in the gaps again?
If you empty the table, this will reset it. Remember with auto_increment that it's supposed to be a unique identifier for a record so in general you wouldn't want to reuse numbers once a previous record has been deleted.