I am developing a site for a client who sells custom computers
in my shopping cart I have a inventory table...how would I set it up to accomodate custom computers...for example a desktop with a base price of lets say 150.00 and now if someone wants to add a monitor then add more money etc etc
I mean am I gonna have to set up a class called custom_computer and have differeent attributes like graphic card, monitor etc all of which make 1 product which is a whole computer.
I guess Im confused please help
create database cart;
create table inventory
(
itemId int auto_increment not null,
itemName varchar(50),
itemDesc varchar(250),
itemPrice decimal(4,2),
primary key(itemId),
unique id(itemId)
);