I've got a data entry form and when it's submitted, data gets entered in to the database. No problem there so far.
There are several tables with the primary table being 'client_details'. in which id is an autonumber field.
Quite a number of my variable depend on $id to perform their calculations, other queries, etc.
What is the best method for obtaining a new client id? My thought is that I write an otherwise blank record then do a max(id) query and assign it to $id but that seems a little clunky to me.
Oh, I've coded my form with a static variable for $id for now.
How would you do it?
Best Method For New Record
Moderator: General Moderators
Re: Best Method For New Record
There are 10 types of people in this world, those who understand binary and those who don't