Change the productID of my entire Product table according to clients changing ranking
Posted on 2011-03-10
My web app presents an entire category of products displayed using (ORDER BY Product.ProductID). My client wants to choose which products are side by side and/or at the top of the page. To add a Rank column to my product table would force the client to manually assign an integer to each product in his catalog. I am thinking there is a way to change the ProductID to accommodate him instead. Some way of reordering the table. If anyone can help by either suggesting code or just tell me I am wasting my time, please do.