Member Avatar
kingben

Hi All...
Any way to auto-increment the last inserted numerical value in the field "id" and then insert the newer value (id+1) in the database upon submitting the form ??? ...... How do i resolve that last submitted "id" ?? .....

I thought of doing that using a txt file as a counter but is this the only way ???

Have you tried the AUTOINCREMENT property on the field in the database? Go take a look at the MySQL manual

Member Avatar
kingben

Have you tried the AUTOINCREMENT property on the field in the database? Go take a look at the MySQL manual

yeah have tried that ...... not working ..... may be am doing something wrong ........ any snippets ???

Yeah, in the MySQL manual there are in-depth explanations, go take a peek.

Member Avatar
kingben

Yeah, in the MySQL manual there are in-depth explanations, go take a peek.

Have figured it out ..... You have to set the "id" field as INT with Primary Key and Auto Increment ...... That's it ....