Checking if Date/Time is Available (and then some more)

[Claunchster]

Okay, so I am stepping out of my as3 skill set here quite a ways and need some bookoo assistance (Flash 5.5). I am working on trying to come up with a way (an AIR desktop application, or web application) for the teachers on my campus to be able to assign students to a variety of detention types, dates/times with limited seating available.  I want the teachers to be able to input the student data and select a date/time or even multiple dates/times, then have the program check to see if there are any available seats remaining for that date/time.  If so, assign the student to that seat.  If not, display the next available seat's date for that time slot with the option to assign student to that date or choose another.

I also want to be able to run a report that will tell me who is serving which detention, when (date/time) and in what room.

I would also like teachers to be able to "re-assign" a student if they needed to for whatever reason, thus freeing a seat in the previous slot and filling a seat in another.

I'm not quite sure where to start aside from the interface design (that I can easily handle). Does anyone know of a good tutorial (or a few) that could get me on my way to try to code all this?

Thanks!

[kglad]

except for making a calendar (http://active.tutsplus.com/tutorials/actionscript/understanding-date-making-a-calendar-in-as3/) there is only logic needed to create that app.

[Guest]

Hmm, there's really no easy answer as you want to do quite a lot. I think your best bet is hooking into MySQL though. That will allow you to query the database for empty seats and such.

[Claunchster]

dmeN, do you know of a good place to start with MySQL?