Menu
Community /Pin to ProfileBookmark
@NogDogAug 25.2007 — #Important question: can a given client ever have more than one case number? If so, then you need to get the case number out of the client info table and into a separate case table, with a third case-to-client relation table.
If not, then the easiest solution might be to insert the new client info record with a 0 or null value for case ID, do a mysql_insert_id() to get the client ID, then do an update to set the case number as that ID + 2000.
Of course, even simpler would be to just have one column as customer/case ID. You can define the column as auto-increment, with the first number being 2000 ("AUTO_INCREMENT = 2000" in the table options section of the create table SQL).
Generate Numbers
Hello:
I hope someone can help me out.
I have a table which stores client information. In this table I also need to store a field called case_number.
My client would like the case_number to be automatically generated when she adds a new client. And, she would like the case numbers to be sequential.
So if I have ClientA in a table with case number 2020 and I add ClientB to the table, I would like their case number to be 2021. And, if I add ClientC to the table, their case number sould be 2022. Etc.
Is it possible to write a script to generate a number in sequential order and store that number into a table?
If so, how do I go about scripting something like this?
Thank you in advance.
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogAug 25.2007 — #If not, then the easiest solution might be to insert the new client info record with a 0 or null value for case ID, do a mysql_insert_id() to get the client ID, then do an update to set the case number as that ID + 2000.
Of course, even simpler would be to just have one column as customer/case ID. You can define the column as auto-increment, with the first number being 2000 ("AUTO_INCREMENT = 2000" in the table options section of the create table SQL).