Quite an interesting quandry I have.
What I have is this:
Table schooltypes:
(typeid is a unique# iding the type, schooltypes is the type of school, say
"Elementary School" or "High School")
| typeid | schooltypes |
Table schools:
(typeid is the type the school falls under, schoolid is the unique# iding
the school, schoolname is the general name like "Park Shore High School")
| typeid | schoolid | schoolname |
Table teachers:
(tuserid is their unique id, salutation is the Mr/Mrs/Miss/Ms/Dr, last name
is well, duh :))
| tuserid | salutation | last name |
Table teachers_schools:
(tuserid is the teacher's id, next to the school they are assigned to. Note
the possiblity for a teacher assigned to more than one school (hello,
cutbacks and skeleton budgets)).
| tuserid | schoolid |
What I need to be able to do is list all this information as such:
School type:
+ School 1
- Teacher and their Teacher ID
- Teacher and their Teacher ID
+ School 2
- Teacher and their Teacher ID
- Teacher and their Teacher ID
- Teacher and their Teacher ID
+ School 3
- Teacher and their Teacher ID
- Teacher and their Teacher ID
Another School Type:
+ School 5
- Teacher and their Teacher ID
- Teacher and their Teacher ID
+ School 7
- Teacher and their Teacher ID
- Teacher and their Teacher ID
Currently, I AM able to list the school type and the school correctly.
However, when I come to listing the teachers in the school, every teacher is
listed under every school, some more than one time.
Any ideas/code snips on how to do this?
In what direction should be I solving this?
Going from type->school->teachers assigned->teacher info?
Or teachers assigned->teacher info->schools->type?
Right now I am doing the first, sorta.
- k
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
