TecBrain

I need some guidance here, am working on a catalogue system, I thought of adding next product and previous product in the back end so that the admin will have
more flexibilities, but am kind of out of ideas, the problem that I cant use the product_key coz , what I mean is this if i have 5 products and delete product 3:

Product_id = 1
Product_id = 2
Product_id = 3
Product_id = 4
Product_id = 5

after ---

Product_id = 1
Product_id = 2
Product_id = 4
Product_id = 5

so i thought of creating a loop and control the next and previous by adding or subtracting 1, but this wont work, anyone got an idea to get me started.
Thanks.

__________________
Personal Portfolio
TecBrain Support Forum
Linux VS Windows ... Dont Even Think of it ..
Distribution: Slackware
if (OS==Linux) return success
There are 10 kinds of people, those who can read binary numbers and those who can't.