Using #'s to differentiate entries

[Dracolas]

How do you set up the page so that when it inserts into the database it takes the next # in a field. as in when you register a member and there is 2 members the page automatically make that member 3... i know it can be done but i can't find the coding to do it.

 

Thanks

[Buddski]

You need to make the 'id' field we will call it an auto-increment.

Mysql will take care of it then

[Dracolas]

ok so do i put anything in the coding on the page?

[Buddski]

Nope..

[Dracolas]

why type do i use?

[Buddski]

int and make it primary key.

[laffin]

and dont assign it in your query

INSERT INTO users SET username='blah',password='bleh';