sql location field, when location changes post a new table row

[jesushax]

i all what im trying to do is

 

i have a sql query that shows records ordered by their location but what i want to do is when the location changes to have a gap in the table so insert a new row, cant think of how to do it though

 

maybe using a for each statement?

[RussellReal]

why would you wanna put gaps in the table if the location changes?

 

and why not just make 2 fields

 

previous_location - location

 

and when you insert the row initially just make previous_location and location the same value.. and then when location changes, leave previous_location and change location..

 

then when you're looping thru your result array, if the previous_location and location don't match up.. than echo a blank row :S