I am just looking for some advice with storing data in phpMyAdmin.
I have a table with is setup like a matrix:
It has place names as column titles and also has the same place names as unique fields in each row - for example:
place_name (unique field)
place_name = Auckland
place_name = Christchurch
place_name = Dunedin
Now, what I want to do is store distances in the remaining fields. So where Auckland is the place_name and Auckland is the column title it will read 0 as the distance.
This is all fine, however I want to store km, miles and driving time in each field that returns a value other than 0 so for instance:
The field where place_name = Christchurch, column title is Auckland will return 1700 (for km), 1400 (for miles) and 17 (for drive time).
My question is - should I store the km, miles and drive time in the database as comma separated values or is this not wise?
Hope this makes sense.