Membership Script: Creating numerical ids for each sign up

ChunkyChunky

I have a membership script i am working with and have a question. Instead of a user entering their own username like "DrJohn99" i would like to have each user assigned a number (starting with a 0 and going up up up)...and also i would like for their email address to be the login.

Probably vague, but i was just wondering if anyone has any general ideas or links....thanks!

schwim

Hey there chunky,

If you create the user's table with the id to auto_increment, it will automatically assign the next available number, something like this:

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,,
  `email` varchar(50) NOT NULL,
  `pass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `email` (`email`)
) TYPE=MyISAM;

then you can echo ID on a page(instead of a username), and you can have them log in with the ID or the email, depending on your preference.

thanks,
json

Piranha

I have one comment on schwin's post:

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL,,
  `email` varchar(50) NOT NULL,
  `pass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `email` (`email`)   // KEY is the same as INDEX. If you use it as login I think it should be unique, and then this row should be "UNIQUE email"
) TYPE=MyISAM;

When you add new rows you should not insert the id, the database handles that for you. When you have added a new user you can use the mysql_insert_id to get the id that was inserted.