Generate Member Number based on next row number in DB

[adzie]

is it possible when entering a new member in the database via a form, that the member number can automatically display the next available row number in the DB?

[zenag]

after insert command 
echo mysql_insert_id()+1;

[adzie]

excellent, the DB has got into a real mess previously as the memebr number was dictated by the person entering the new members details of a spreadsheet.  Hopefully this will help to keep things 'tidy'

[PFMaBiSmAd]

Because of the possibility of concurrent access, you CANNOT use mysql_insert_id()+1 for any purpose other than to display the number. As soon as you attempt to actually use that number, you will eventually create a mess with multiple records having the same number in it.

 

You need to use an auto-increment field to insure uniqueness.

[adzie]

the field ID which is the table key is also autoincrement