Hi, I am having some troubles with the syntax of my SQL statement to fit them into a certain layout. Would appreciate if anyone can provide me with advise.
In my database, i have 5 fields ( nameid, name, number, section, role) Each person is only assign 1 role(A, B or C).
In my webpage, the list is to display the name, id, number and role each person play based according to the different sections. Thus in the website there are 4 columns(Role, Name, Nameid, Number). However,I would like to include an additional row to display the name of the sections thus will have to insert rows in betweens the names whenever there is a new section.
Eg.
Role, Name, Nameid, Number
Section X
B, tom, 01, 1111111
A, evelyn, 02, 2222222
Section Y
C, carolyn, 03, 3333333
C, matt, 04, 4444444
In my database, i have 5 fields ( nameid, name, number, section, role) Each person is only assign 1 role(A, B or C).
In my webpage, the list is to display the name, id, number and role each person play based according to the different sections. Thus in the website there are 4 columns(Role, Name, Nameid, Number). However,I would like to include an additional row to display the name of the sections thus will have to insert rows in betweens the names whenever there is a new section.
Eg.
Role, Name, Nameid, Number
Section X
B, tom, 01, 1111111
A, evelyn, 02, 2222222
Section Y
C, carolyn, 03, 3333333
C, matt, 04, 4444444
