Sorry didnt make it that clear.
Say there is a "trip", and there will be many of these trips.
For each trip there will be various readings taken at a fixed time interval. The number of readings is constant but the number of time intervals may vary, and there will be lots of them. I don't need to have a reading description as i know what each reading is.
For example: (readings are separated by commas)
... (possibly hundreds of sets of readings)
Each trip needs additional information along with it. The readings will not need to be edited at all.
I definitely want to store it in a database, but im justing wondering how best to store it in the database.
For example, one option is to have 2 tables:
tripid, name, otherinfo, time_interval
5, Trip name, something else, 00.05
id, tripid, reading1, reading2, reading3
1 , 5 , 34 , 54 , 65
2 , 5 , 65 , 24 , 35
3 , 5 , 26 , 54 , 65
but i think there may be a better way since these readings are fixed and dont need to be individually edited etc..