I'm looking to build a database which will integrate with something like FusionCharts. Therefore, I'll be storing data over a weekly period to display in the relevant graph.
However, I've got a couple of questions about the best way to set this up:
- How should the fields be labelled in the database? Just something generic like 'Day 1' through to 'Day 7'?
- How do I ensure that the PHP script enters the right value in the right field? Is there some way of saying in PHP insert the value into 'the next available field?'
- And equally what would you recommend I do at the end of each week? Just overwrite the data? Or store it in a separate table somewhere?
Thanks a lot in advance,