Is there a php code that for every time a user comes it goes up 1?

[DrewM]

Well I'm trying to make a link page where my users can add a link it does every thing right except when you save becausethe id is already on use. So can some one tell me a php code that for evry time the user saves it goes up 1.

[Lea Verou]

I think that if you define a column as "auto_increment" this happens automatically. I'm not sure though...

[Xenon]

if you store it in the db, yep then just make the id field an autoincrementfield

[DrewM]

thank you

when I do this it comes with the error:
#1063 - Incorrect column specifier for column 'id'

[Vizionz]

CREATE TABLE tablename (id int(6) NOT NULL auto_increment,
otherstuff varchar(15) NOT NULL,
youneed varchar(15) NOT NULL,

[DrewM]

thank you.