I'm having some logic troubles. I'm trying to write a roster database.
It needs to have a:
1) A start time for each day of the week
2) A Staff type + Staff Name
3) A location for each day
So when the user sees the roster theres a seperate table for each Location and within those tables, mini-tables for each staff type. Now each staff member doesn't neccasarily work at the same location the entire week.
So coding for a location for each day is what having I'm trouble with. [i have made solutions but they seem really clunky to me, like first loading the entire table into a multi-dimensional array and using that).
At the moment my table looks like: staff_type, staff_id, monday_location_ID, monday_start_time etc...
Please help me before I tear my hair out!