How can I do this

<bump!>

Hi thesofa,
This is an interesting one. Stuff like this gets my noggin thinking.

I would bet that phprunner, a little javascript and some ajax would get you your solution.

I do not have an absolute answer here, just throwing ideas around.
Classroom - layout, furniture

Classes - In what classroom

Students - in what classroom in what seat.
If you have a classroom table, I would add a blob field to it.

Then I would try and find a way I could get your 47 classrooms layouts into gifs or jpegs and load them up to the appropriate classroom record.
I would think the classrooms will never change in shape or size. Im sure there will be different types of furniture in some of the classrooms, and I would imagine the teacher would want to move the students around too.
So I could see when you view a classroom record, the list of students in the classroom would be on the left, and in a right panel your classroom image displayed, where you could drag and drop the students over the layout image and thus assign them to a desk. This is where there are some nice drag and drop ajax samples on www.dhtmlgoodies.com.

The samples show how to write to cookies to save the drag and drop information in cookies, but I would think you would want to write them to the student table for more permanent saving. This way you could lookup a student, and see exactly where he is supposed to be seated right now.
I wont ramble on here, I may be just wasting your time. Just some thoughts.

Hi

Tis the thoughts that I need, I was thinking more of a table for each layout, table as in Visual editor type table rather than database type table.

Not worried about exact furniture types, just the positions where the little darlings sit.
For the "list" page
So, 5 days of the week, 6 lessons a day.

Repeats fortnightly to give 10 days of 6 lessons.

teacher walks in to room H6

logs on to pc

loads application or web page

selects room H6

gets offered a default of the day and the lesson number

(this allows for changing layout before or after a lesson

sees a 5 by 6 grid of places with names in the grid cells, admission number below each name. Or a different grid depending on the room.

A neat trick would be picture if click on name?

or better still, spikes coming up through the seat if click on name.........

The edit page could be a drag and drop system, or just retype the admission number (6 figures, easily available from lesson monitor) in the old place so when record saved, new kid is in place.
Drag and drop would be lovely, but I suspect beyond my means ATM

I have suggested a paper system, and hang the sheets on a nail, a bit like the old toilets.....

I digress again.

Thanks for the help, any more ideas anyone?
Even better would be if I could make this a live desktop, showing the seats as the background wallpaper from a aset of tables.

<a bigger bump>