Hi all. ive just this minute joined the forum. Im looking to redesign a web ste for a friend. He's a landlord and has a bunch of houses (30 or so) that he rents out to students. He wants to be able to store and change all the nformation about these houses in a database, and have the property information pages on the site dynamically populated and updated.
My idea was just to create seperate html pages from the information not linked to a database, because im not familiar with databases. but this would mean later on, changes to the database would have to be repeated for the website, so maybe it is a good idea to roll everything ot one.
Im not sure quite how to go about it, ive heard about sql and ms access and oracle and all, but dont really understand what they all are, or what they actually do, whether they are software products or what, whether they would be installed on the server or my friends computer. if its on the server how to you interact with it or even go about setting it up.
I understand that there would be a database, and on the website there is somekind of fetch command or something, but im obviously missing alot because it seems to me that it should be possible to upload a excel spreadsheet and fetch information from that somehow.
I d really appreciate it someone could lay down a simple step by step plan for getting something like this set up, or let me know where i can find information to educate myself, and get my head around it all.