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.

DaWei

You need to be clearer on what "next" and "previous" are in relation to. A set returned by a query? There are no real "next" and "previous" anything without specifying context.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Mocker

might be an easier way, but you could do something like

previous, SELECT * FROM product_table WHERE product_id < var_previousID ORDER BY product_id DESC LIMIT 1


next, SELECT * FROM product_table WHERE product_id > var_previousID ORDER BY product_id ASC LIMIT 1

that should just select one record, either the next greatest product id, or next smallest

__________________
#programmingforums relay - http://thegupstudio.com/cgi-bin/pforelay.cgi
freelance scripts - http://ryanguthrie.com/index.html

ASHORY

go here it may help you .

http://www.phpfreaks.com/tutorial_ca...Pagination.php

__________________
"^Ahmed.SHOukRY^"
http://www.ashory.741.com