> My table has an INT column named 'member_id' which is set to
> It works very well but I have inserted and deleted some test rows during
> development stage and now my incremented numbers have jumped ahead.
> The deleted rows (their member_id values) have not been forgotten it seems
> and the DB is using them still to evaluate the next number.
Assuming we're talking about MySQL, ALTER TABLE will do the biz:
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php