ID incrementing for multiple users - please help

[eluser]ejangi[/eluser]
Yeah, you could have separate tables for each user and set the AUTO_INCREMENT value to start at 1000.

Code:

create table user_###
(
id MEDIUMINT NOT NULL AUTO_INCREMENT,
....
) AUTO_INCREMENT=1000;