yes i figured that thing i just want to know how i will be able to do that?
2009/11/17 nu1silva <[email protected]> > hi all, > > im developing a Student Management software and im just going through > the registration of a student. > > i need to assign the registration number --> T(year)-(# of > registration for the year) so it'll be like > T09-001 or T09-089 or T09-243 an so on.... > > i get the input of the year and can count the number from the > database. > > how can i get the registration number? > > the sample o the Student Database... > > CREATE TABLE Student_Details > ( > Student_ID varchar(10) NOT NULL UNIQUE, -- example ( > T09-001 ) > Fname varchar(255), > Lname varchar(255), > Full_Name varchar(255), > -- > Address varchar(255), > DOB datetime, > ContactNO varchar(15), > email varchar(25), > additional_detail varchar(255), > Course_ID varchar(10), > Dateof_Admission datetime, > --Dateof_Graduation datetime, > PRIMARY KEY(Student_ID) > ) > > > help!!! :( > -- Thank You, Best Regards, Nuwan S. Silva 170, St. Anthony's Road, Moratumulla, Moratuwa, Sri Lanka. Mobile : +94 779 804 543 email : [email protected]
