1、实现功能
(1)选择文章进行推荐位新增
(2)推荐位的查询、编辑和删除
2、数据字段表
CREATE TABLE `cms_position` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` char(30) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '1',
`description` char(100) DEFAULT NULL,
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`update_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
CREATE TABLE `cms_position_content` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`position_id` int(5) unsigned NOT NULL,
`title` varchar(30) NOT NULL DEFAULT '',
`thumb` varchar(100) NOT NULL DEFAULT '',
`url` varchar(100) DEFAULT NULL,
`news_id` mediumint(8) unsigned NOT NULL,
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`create_time` int(