So I'm pretty new to php and mysql and have been searching for an answer to this for day's with no success and I figure the reason is I'm asking the question in the wrong manner.
Here is what I'm want to do:
I have a work order form that I currently enter the next available work order number in manually based on what the last number used was and the ticket is filled out then submitted to a mysql db.
I'm looking for a way to auto generate a new work order number based on the highest number existing in the mysql db and increment that number by 1 and have it auto populate the box.
is there a simple way to do this using java, jquery, ajax or just plain php with the mysql on duplicate command?