Any Ideas
Posted: Tue Jan 06, 2004 4:12 am
Hi All,
I need some ideas how to do this.
I have a table with students and a realtional table with siblings containing the oldest students ID related to a student who is related to this oldest student. Also the student is related to him/her self in this table.
for example
tbl_student (stid, st_name, st_adr etc)
tbl_student_sibling(ssid, frn_stid, frn_ssid)
i'm writing a template to display all the oldest students with a count for the number of siblings they have. On each page, 10 records will be displayed. Any ideas how i can do the next and previous so that the same student does'nt get displayed and the siblings dont get displayed??????
I need some ideas how to do this.
I have a table with students and a realtional table with siblings containing the oldest students ID related to a student who is related to this oldest student. Also the student is related to him/her self in this table.
for example
tbl_student (stid, st_name, st_adr etc)
tbl_student_sibling(ssid, frn_stid, frn_ssid)
i'm writing a template to display all the oldest students with a count for the number of siblings they have. On each page, 10 records will be displayed. Any ideas how i can do the next and previous so that the same student does'nt get displayed and the siblings dont get displayed??????