Efficient sql statement

[Anon]

I am wondering if any one knows away of performing the following in sql.

I have a table with 4 fields(id,start,stop,date,time) I am trying to perform a data integrity check on some info.

What I need is a script in either sql or php that will for each record determine if the stop time of the current record is equal to the start time of the next record. This of course would loop for a specific time frame. If the they are not equal it would continue to run but store the id of the records not equal in an array.

thanks

[Anon]

sql: (stores results in another table "store_table")

select t1.id into store_table from your_table t1, your_table t2 where t1.id=(t2.id-1) and t1.stop<>t2.start;

this may take some time (if table is large)
so make sure you've indexed the id column

hope this helps