•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,222 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,280 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 205 | Replies: 1
 |
•
•
Join Date: Jul 2005
Posts: 51
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Before I continue, quick explanation:
product table
pid (primary key), pdesc (Product discussion), and pquant (quantity of product).
I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM).
Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch versions and 3.5 inch version, in which case we have different quantities of each. I didn't set the pdesc as a primary key, so theoretically since each product is described by the pid, i should be able to have duplicate pdesc but it isn't working.
Any ideas?
product table
pid (primary key), pdesc (Product discussion), and pquant (quantity of product).
I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM).
Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch versions and 3.5 inch version, in which case we have different quantities of each. I didn't set the pdesc as a primary key, so theoretically since each product is described by the pid, i should be able to have duplicate pdesc but it isn't working.
Any ideas?
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
Hello
Because both products differ in an important property they must have different part numbers. So you are able to manage different quantities, deliverers, prices, taxes etc.
You may put them into same category, for example "hard disks" to get a list of all hard disks if necessary.
krs,
tesu
Because both products differ in an important property they must have different part numbers. So you are able to manage different quantities, deliverers, prices, taxes etc.
You may put them into same category, for example "hard disks" to get a list of all hard disks if necessary.
krs,
tesu
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
Other Threads in the MySQL Forum
- Previous Thread: Mysql IsNull check
- Next Thread: Problem with using DECODE
