Hi,
I have a DB with this structure:
I need an Articles CMS that can work with it (SE friendly, Mod_Rewrite, Good admin panel)..
Please post/pm if you have anything to offer.
Thanks,
E-A.
I have a DB with this structure:
Code:
DROP TABLE IF EXISTS articles;
CREATE TABLE articles (
id int(10) unsigned NOT NULL auto_increment,
categ int(3) unsigned NOT NULL default '0',
title varchar(250) default NULL,
author varchar(250) default NULL,
date_pub int(20) unsigned default NULL,
site varchar(200) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id(id),
KEY categ(categ)
) TYPE=INNODB;
#
INSERT INTO articles VALUES("1", "1", "Sell More Books With an E-mail Newsletter", "Alexandria K. Brown", "1126962450", "ezinearticles.com");
#
DROP TABLE IF EXISTS articles_text;
CREATE TABLE articles_text (
id int(10) unsigned NOT NULL default '0',
content text,
KEY id(id)
) TYPE=INNODB;
INSERT INTO articles_text VALUES("1", "<p><i>NOTE: Because many words in this article are likely to trigger sp^m filters, we\'ve disguised them with symbols (e.g. sp^m). This will ensure a higher delivery rate if you use this article in your e-zine.</i></p>\r\n\r\n<p>If you\'re selling your... at the END of my sig file, after my contact information: \"BOOST BUSINESS by publishing your own e-mail newsletter! Learn how now ? sign up for fr*ee how-to tips at http://www.ezinequeen.com.\"</li>\r\n</ol>\r\n\r\n<p>(c) 2000-2003 Alexandria K. Brown. All rights reserved.</p><p>ABOUT THE AUTHOR</p>");
Please post/pm if you have anything to offer.
Thanks,
E-A.

Comment