Pinball Posted January 27, 2013 Share Posted January 27, 2013 Does anyone know how the numbers for the "ID" (Primary) of XSell in products_xsell are generated? If they are simply adding one to the previous number that is great, but I see large gaps in the number sequence so was trying to figure out what made it. I do know that products_id is the number of the 1st product item, and that xsell_id is the cross-reference to the other items products_id, and finally that sort_order is, well, the order several items are show if there is more than one XSell item (each is linked to the next until you reach the end of the chain). I am working on an open source database manager using LibreOffice BASE (OpenOffice BASE didn't work so well when I tried it earlier this year) and this question popped up on me while experimenting with displaying the XSell data relative to the Product ID. I could read through the XSell code I guess, but was hoping someone knew off the top of their head what the answer is. Quote Link to comment Share on other sites More sharing options...
♥kymation Posted January 27, 2013 Share Posted January 27, 2013 They're generated automatically by the database. They are usually in sequence, but gaps can occur if you deleted something. Regards Jim Quote See my profile for a list of my addons and ways to get support. 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.