Part Numbers in mysql table for web cart?
luvv2rock asked:
I am working on a database for a shopping cart system I’m building. I’ve built several in the past however I have a delima this time. Some of my parts (about 1000) have the same part number. In the inventory system it is stored as a line number then part number and I’m thinking of doing the same for my database (ie ORE, 92-621) what should I use for my id? Should I just have an auto ID or does it really matter?
Ok so I’m sure now to have a unique ID. But how can I do this? If i put an autonum ID for each part will I be able to update ID where partnum is parttype so that I update the correct ID?
I am working on a database for a shopping cart system I’m building. I’ve built several in the past however I have a delima this time. Some of my parts (about 1000) have the same part number. In the inventory system it is stored as a line number then part number and I’m thinking of doing the same for my database (ie ORE, 92-621) what should I use for my id? Should I just have an auto ID or does it really matter?
Ok so I’m sure now to have a unique ID. But how can I do this? If i put an autonum ID for each part will I be able to update ID where partnum is parttype so that I update the correct ID?
Recent Comments