Auto_increment

[Anon]

Dear All,
I created a DB table in MySQL in which one field is integer with AUTO_INCREMENT. How to increment this value automatically when a user decided to enter a new row of data into that particular table? I am badly in need of this. Please help me.
Indrajit.

[majik-sheff]

In your SQL:
INSERT INTO access (field, names, go, here) VALUES ('field', 'values', 'go', 'here')

Just leave the auto-increment field out entirely in your query and mysql will take care of it for you. If you then call
mysql_insert_id() (check the manual)
it will tell you what the number was that went into the auto-insert field.

[Anon]

Thanks for your help. It is working now perfectly.