Appointments application

Hi all.

I'm having a problem in designing an e-clinic website for patients to
make appointments with doctors. I can build the login,patients' and
doctors' pages but I don't know how to do the appointments.
Is there any "all-purpose" appointments application with php and mysql
that I can customise to my requirements somewhere?
Please help me out with this people.

Thanks in advance.
Sara

Hi

First what you need is to design the mysql tables. An easy and simple table for your application should and must have following fields :

id
patient name
doctor name
date
time
reference number

.You can add the fields as you want to suit your application.

Whenever each appointment is made, you should add it to the table and similiarly you can perform a cross check to avoid clashes of time.

Thats all, ..

so basically what you need is

1. design the database
2. Write scripts to connect from your html pages
3. Perform the appropiate steps : i.e : insert into table. check the available time, display the available time for each doctor and so on.

Hope that helps