Creating a database

Next I thought of creating a database of the clinics. This way I could make pages for each clinic. I made three tables; one for clinics, one for schools, and one for villages. The villages will have location and population. The clinics and schools will have their location, dedication date, and names of files for images and such.

I got that created and filled in a bit. I also created a page to show a list of the clinics and then something about the clinic when you click on it. I had to learn how to do a join to get some info from the village table. The bulk of the code I reused from our player piano roll project.