Anybody out there seen a tutorial on this, or at least get me pointed in the right direction.. I have created this database table which holds all the field information..
Code: Select all
DROP TABLE IF EXISTS `dw_fields`;
CREATE TABLE `dw_fields` (
`field_id` INTEGER unsigned NOT NULL auto_increment,
`field_category` varchar(255) NOT NULL default '',
`field_name` text NOT NULL,
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `dw_fields`
--
INSERT INTO dw_fields VALUES(1, 'Customer Information', 'Bride');
INSERT INTO dw_fields VALUES(2, 'Customer Information', 'Groom');
INSERT INTO dw_fields VALUES(3, 'Customer Information', 'Address');
INSERT INTO dw_fields VALUES(4, 'Customer Information', 'City');
INSERT INTO dw_fields VALUES(5, 'Customer Information', 'State/Province');
INSERT INTO dw_fields VALUES(6, 'Customer Information', 'Zip/Postal Code');
INSERT INTO dw_fields VALUES(7, 'Customer Information', 'Phone Number');
INSERT INTO dw_fields VALUES(8, 'Customer Information', 'Email Address');
INSERT INTO dw_fields VALUES(9, 'Wedding Information', 'Wedding Date');
INSERT INTO dw_fields VALUES(10, 'Wedding Information', 'Approximate Time');
INSERT INTO dw_fields VALUES(11, 'Wedding Information', 'Location');
INSERT INTO dw_fields VALUES(12, 'Wedding Information', 'Reception');
INSERT INTO dw_fields VALUES(13, 'Wedding Information', 'Color Scheme (if applicable)');
INSERT INTO dw_fields VALUES(14, 'Wedding Information', 'Approximate Number Of Guests');
INSERT INTO dw_fields VALUES(15, 'Wedding Information', 'Type Of Ceremony');