Hey all, I hope it's ok to post this question here...if not, please move to the appropriate forum.
I'm beginning a new site for a client and they are not very computer savvy, none the less web savvy. As a quick summary: The site is informational and needs to tie into a database so that what is in the database is posted on the web. There are a dozen or so fields for each record and the idea is that the information gets requested by the web pages. So, it's dynamic, but the user is not selecting what information is displayed, that part is programmed into the page. They want to be able to update their site on their own once it has been created. It has to be very basic thus, no FTP, no web creation software, etc.
I am learning PHP so that I can hopefully build the html pages and then place in the php where needed for the dynamic part.
My question is this: In the long run, which of these two would be easier to use for the database: MS Access or MySQL? I know a bit of Access, and not very much about MySQL. Whichever it is, I was hoping that I could create "admin" html pages where the owners can update the data in the database to update the website. I think this would be the easiest way since they are very non-technical people.
I first thought it would be easier to create the DB in Access and then just use Access Data Pages for them to update the DB, but after playing around with it, I'm no longer sure that's easiest. However, I haven't really used Access Data Pages very much, so I shouldn't judge quite yet.
Any recommendations as well as examples of or links to this type of scenario would be greatly appreciated! I'm sure I'm in for a bigger project than I imagined, but hopefully it won't be too difficult.