Appointment Scheduling Web page/site 1

[SgtBeck]

Alright here is what I'm trying to do, I am trying to create a web page (either by using note pad or web developer) that will allow the following:

- end users will be able to view available appointment times (mon - fri 7:45 - 9:45 and wed. additional appointment times from 3:00 - 5:00; saturdays and sundays should automatically be blocked off from being able to book appointments)

- end users will be able to book an appointment or edit/delete their own appointment based on only those appointment times that have not already been used (1 for every 15 minutes example: 7:45 one appointment, 8:00 one appointment)

- administrator access to allow admin to be able to designate a specific date such as holidays as closed so that appointments can not be made that day

- admin access to also delete/edit/add appointments

I have been working on this for about 5 weeks and come to a dead end every time, if you could provide any help it would be greatly appreciated.

 

[Sheco]

Do you have a database structure?

 

[SgtBeck]

Yes I have a database, but a simple one it just has a few tables, I tried doing some date/time manipulation with the queries but couldn't come up with anything.

 

[Tarwn]

So what are you looking for, more specifically?

You already have a database and are writing some queries, and have come to a dead end,but you didn't really tell us where you came to a dead end

I don't want to try to give you any exmaples at this point simply because my database structure would probably look very differant from yours and then it could take us ages to get an exmaple posted here to work in the existing code you have. If you could be more specific on where your stuck and maybe post some of the code form right before your stuck to give us an idea how things are working up to that point, we should be able to help you get past the area your stuck on.