jesushax Posted July 15, 2009 Share Posted July 15, 2009 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? Quote Link to comment Share on other sites More sharing options...
RussellReal Posted July 15, 2009 Share Posted July 15, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.