Reply to thread

Message

<blockquote data-quote="Joe" data-source="post: 383371" data-attributes="member: 18160">There is only one cms_news ?_?The two entries you're seeing are two completely different news articles - which looks right?However, I would recommend an IIS/Navicat setup rather than phpmyadmin (it looks like)Your cms_news looks a little wrong though - here's the correct format.[CODE]-- ------------------------------ Table structure for cms_news-- ----------------------------DROP TABLE IF EXISTS `cms_news`;CREATE TABLE `cms_news` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,`shortstory` text COLLATE latin1_general_ci,`longstory` text COLLATE latin1_general_ci,`published` int(10) NOT NULL DEFAULT '0',`image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',`campaign` int(1) NOT NULL DEFAULT '0',`campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL,`author` int(6) NOT NULL DEFAULT '1',PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;[/CODE]</blockquote>

[QUOTE="Joe, post: 383371, member: 18160"] There is only one cms_news ?_? The two entries you're seeing are two completely different news articles - which looks right? However, I would recommend an IIS/Navicat setup rather than phpmyadmin (it looks like) Your cms_news looks a little wrong though - here's the correct format. [CODE]-- ---------------------------- -- Table structure for cms_news -- ---------------------------- DROP TABLE IF EXISTS `cms_news`; CREATE TABLE `cms_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL, `shortstory` text COLLATE latin1_general_ci, `longstory` text COLLATE latin1_general_ci, `published` int(10) NOT NULL DEFAULT '0', `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png', `campaign` int(1) NOT NULL DEFAULT '0', `campaignimg` varchar(255) COLLATE latin1_general_ci NOT NULL, `author` int(6) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members