I need a news entry page. ? I'd like to use tinymce or like system. I need to be able to add photo's as well.
There are a couple other fields as well. ? I think they spea for themselves. ? Count, nComments and newstype will just be filled in with a '0'.
CREATE TABLE `news_article` (`id` int(11) NOT NULL auto_increment,`title` varchar(80) NOT NULL default '',`pdate` varchar(11) NOT NULL default '',`sdesc` varchar(254) NOT NULL default '',`story` text NOT NULL,`newstype` tinyint(2) NOT NULL default '0',`nComments` int(8) NOT NULL default '0',`count` int(11) NOT NULL default '0',PRIMARY KEY (`id`),UNIQUE KEY `id` (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=175 ;
I would also like the ability to delete/modify these stories.
I will also need it password protected. ? You can hard code the id and password in an config file. Its just me so no need to have it in the db