Sizes option
Here is an example of what i want to achieve www.bricabrac.me/ and the tables in my database
Database: `mario1`
--
-- --------------------------------------------------------
--
-- Table structure for table `items_table`
--
CREATE TABLE IF NOT EXISTS `items_table` (
`Items_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Items_Name` varchar(45) NOT NULL,
`Items_Thumbs` varchar(45) NOT NULL,
`Items_Description` varchar(45) NOT NULL,
PRIMARY KEY (`Items_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `items_table`
--
INSERT INTO `items_table` (`Items_ID`, `Items_Name`, `Items_Thumbs`, `Items_Description`) VALUES
(1, 'Margherita', 'Pizza_1.jpg', ''),
(2, 'Milano', 'Pizza_2.jpg', ''),
(3, 'Hawaiin', 'Pizza_3.jpg', ''),
(4, 'Carabbean', 'Pizza_4.jpg', ''),
(5, 'Pollo', 'Pizza_5.jpg', ''),
(6, 'Yanks', 'Pizza_6.jpg', ''),
(7, 'Toscana', 'Pizza_7.jpg', ''),
(8, 'Mexican', 'Pizza_8.jpg', ''),
(9, 'Greek ', '', ''),
(10, 'Vegtarian', '', ''),
(11, 'American', '', ''),
(12, 'Four Seasons', '', ''),
(13, 'Garlic Pepperoni', '', ''),
(14, 'Mighty Meaty', '', ''),
(15, 'Sea Food', '', ''),
(16, 'Hot and Spicy', '', ''),
(17, 'Mario''s Special', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `price_table`
--
CREATE TABLE IF NOT EXISTS `price_table` (
`Items_ID` int(10) unsigned NOT NULL,
`Sizes_ID` int(11) DEFAULT NULL,
`Price` decimal(5,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `price_table`
--
INSERT INTO `price_table` (`Items_ID`, `Sizes_ID`, `Price`) VALUES
(1, 1, 2.50),
(1, 2, 3.99),
(1, 3, 6.50),
(1, 4, 9.20),
(2, 1, 3.00),
(2, 2, 5.50),
(2, 3, 7.90),
(2, 4, 9.99),
(3, 1, 3.00),
(3, 2, 5.50),
(3, 3, 7.90),
(3, 4, 9.99);
-- --------------------------------------------------------
--
-- Table structure for table `sizes_table`
--
CREATE TABLE IF NOT EXISTS `sizes_table` (
`Sizes_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Description` varchar(45) NOT NULL,
PRIMARY KEY (`Sizes_ID`),
UNIQUE KEY `Sizes_ID` (`Sizes_ID`),
UNIQUE KEY `Sizes_ID_2` (`Sizes_ID`),
UNIQUE KEY `Description` (`Description`),
UNIQUE KEY `Description_2` (`Description`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `sizes_table`
--
INSERT INTO `sizes_table` (`Sizes_ID`, `Description`) VALUES
(2, '10"'),
(3, '12"'),
(4, '14"'),
(1, '7"');
Thank you