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!!! :(
