Thanks for your reply.....
ok here goes let me try to explain this better.....
I have a Db that holds lots of records.
each record has a unix epoch timestamp.
the records are usually 60 seconds different
so i would like to run a query say somthinge like:
SELECT * FROM table WHERE date_logged BETWEEN 12/06/07 00:00:00 AND 12/06/07 23:59:59 ORDER BY date_logged ASC
//the timestamp will be in unix format i have done it this way just for demonstration purposes //
this might produce 200 results, then i would somehow, either PHP / MySQL query (whatever would be the easiest) to do the following...
display the following links:
Trip 1 = 12/06/07 00:00:00 to 12/06/07 01:23:50
Trip 2 = 12/06/07 03:43:30 to 12/06/07 06:55:10
if i run then a query between the above times it might then only return 20 results.
but somehow i need to be able to distinguish between the multiple trips, so if there is a gap of more than 900 seconds, between any 2 records i know that is the end of trip 1 and the start of trip 2.
Please let me know if this is any clearer