I need a guiding hand, how do I display the " current week" starting on Monday , in a 7-day calendar by a 7-room grid, for a small theatre I volunteer at, various voluntary town groups use the rooms.
My database name=rooms, table=roomdiary, it has 7 fields (field_1 to Field_7).
I can populate each day with data from the dbase using the "Select" query & php isset code where required. But I am stumped on how to correctly display only " current week " data in the right room on right day. >
////// Mon... Tues . Wed .. Thu .. Fri . Sat .. Sun room 1 data . data . data . data . data data . data room 2 data . data . data . data . data data . data room 3 data . data . data . data . data data . data room 4 data . data . data . data . data data . data room 5 data . data . data . data . data data . data room 6 data . data . data . data . data data . data room 7 data . data . data . data . data data . data
I apologise for having not posted any code, as I thought any generic advice would be more than helpful and help me learn. Any guidance would be appreciated.