increment drop down list category id

[greedyisg00d]

I have a drop list which the values are retrieve from the database

id name
1 meeting
2 conference
3 workshop

I also included a textbox field where user can add drop down values. My question is for example when the user adds a value "seminar" in the database, its id must be 4 which goes like this.

4 seminar

Any idea on how it will be? Sample code is much appreciated.

Thanks

[bradgrafelman]

INSERT INTO myTable (name) VALUES ('seminar')

since 'id' should be an AUTO_INCREMENT field and thus left out of your INSERT queries.