Hello,

I would like to be able to reset the auto-increment value on certain tables (ex: categories, listings, accounts etc...) in the likely event that I will have unwanted/spam listings in many different rows in the db.

note that this code:
Code:
Only registered members can view the code.
is not what I am looking for as it only works if the rows deleted are in a "row" meaning one after the other.

For example take the following scenario in the listings table:

Rows 1 - 100 are perfectly acceptable listings
Rows 101 - 200 are unwanted listings
Rows 201-300 are perfectly acceptable listings.

How can I remove rows 101-200 (unwanted listings) and keep the row count intact (having continuity) ?

I have found a link online that explains a very technical way (from my point of view) to fix this, but it goes beyond my knowledge and would like to know if using any of the methods on the following link would be ok to use in the flynax system.

https://stackoverflow.com/questions/...nt-primary-key

Brian