Jumping unavailable rows while using a for loop
Posted: Thu Mar 02, 2006 11:33 pm
Hi,
i tried searching the forum if this has been mentioned before, but i didnt find any posts so here goes
i have a table containing some information which i constandly edit including deleting some rows without updating them hence creating a break in the incremental continuity of the tables id.
If a particular field is to be displayed on a webpage using a for loop, any ideas how that can be done without getting the errors "unable to jump row .." ?
since i delete rows regularly, my method of using the for loop is to have initially stored the highest id value in a seperate table which will be used for the upper limit of the for loop.
I was also wandering if there was also a better method to get the results done
Regards
i tried searching the forum if this has been mentioned before, but i didnt find any posts so here goes
i have a table containing some information which i constandly edit including deleting some rows without updating them hence creating a break in the incremental continuity of the tables id.
If a particular field is to be displayed on a webpage using a for loop, any ideas how that can be done without getting the errors "unable to jump row .." ?
since i delete rows regularly, my method of using the for loop is to have initially stored the highest id value in a seperate table which will be used for the upper limit of the for loop.
I was also wandering if there was also a better method to get the results done
Regards