Re: [Dave] List: - Get Options from Database
Are you offering to help with the code or the scotch? [;)] You're welcome either way but you'll have to travel a bit to the east to help with one of them.
On more serious notes, I've drawn a blank on this issue. I can get the Section Editors to behave properly but I think my schema is fouled up. It even lead to some dire messages about the site being overworked from CMSB. Glad to have those catches in the system though!
If you're up for some experimentation, here's my very simple table:
-- Table structure for table `cms_categories`
--
CREATE TABLE IF NOT EXISTS `cms_categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`categoryName` varchar(30) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `cms_categories`
--
INSERT INTO `cms_categories` (`id`, `categoryName`) VALUES
(1, 'Nutrition'),
(2, 'Workplace Wellness'),
(3, 'Smoke-Free Living'),
(4, 'In Motion'),
(5, 'Speical Projects');
If you can show me how this schema should look I would be very greatful.
Cheers,
J.