This is my first post here so please be gentle.
What I need to do is so simple that I couldnt find one example on the web that I could learn from. I don’t have the time to actually start to learn PHP/MySQL right now as I have a deadline to get this done by but once this little project is outta the way I am definitely going to start studying this! Anyway, here’s what I’m after:
I need to be able to allow another user to change some text on a web page on a daily basis.
They would do this by accessing an unpublished page that I would give them the URL to (no login required - I want to keep this as simple as possible).
Once there they would enter the required data into a form, click submit and the new data would appear on the web page, replacing what was already there.
I’ve already created a MySQL table with 1 row and 5 fields. I’m not using an id field as their won’t be any additional rows added. The data will only be updated/changed. I used varchar or char for them but I’m sure that is a mistake.
Here is a graphic of what the area I want to edit looks like. I only want to change the highlighted data: date, numbers under the years, the percentage, and the number of murders in last 24 hours. (this is for a police site). If anyone wants to, maybe they can go one step further and share how might be able to have the proper arrow graphic (up or down) appear next to the percentage based on its value (negative/positive).
Is this simple or am I just too stupid to know?
Hope someone can help me out on this.