Is there an 'easy way' to grab two rows of data from a table, and add rows with values 'in-between'?
I want to grab a latitude, a longitude and a timestamp from each row. Compare the timestamp to the one from the previous row, and interpolate new rows if the timestamp is bigger than my minimum...grab two rows 1 minute apart and add rows for every 10 seconds...
Is using a stored procedure the best way to go about this? Easiest?
Currently using mySql and PHP...