Getting started with inventory

[SATitan]

Hi all,

 

I'm pretty new to php + sql, at the level where I'm getting things to work by experimenting. I was hoping someone could point me in the right direction of something I wanna do:

 

I'm working on an administration tool for a music school, where teachers can set dates for their one-to-one lessons. In short selecting a date for a lesson from a dynamic list populated with sql values. When the teacher assigns a lesson to a student, then (obviously) it won't be avaliable for other students. From this I want to make a display page of all avaliable lessons for front-end users of the school webpage to pick from. (However, nothing is meant to happen when front-end users pick lessons, other than an email to an admin)

 

I realize this might be a big deal. But any tips, and any hints in the right direction is valuable.

 

Thanks!

 

Sabre

[revraz]

I am not sure of what type of help you are asking for.  What you are explaining would be a great learning project for you.  All I can say is research how to insert/update/delete to a DB, how to display rows, and how populate lists from your DB.

 

Start small, get one thing working at a time, then move on to the next part.

[Maq]

It's much easier for people to help if you have actually attempted to code this project.  Because we can look at specific code and give you a solid answer.  If you ask this question on any forums you're going to get the same answer.  So try it out and give us the code and  the errors.  Good luck!