i m developing helpdesk web application.Basically, this system required a employee to first log the Incident so for each incident i have to generate a specific ticketnumber as a reference number so the emp can refer this ticketnumber to see the status of the incident. so plz can anyone help me tht how to provide this autogenerate ticketno. and how it can store in database. ?
In table i have taken one field ticketno as primary key.