rallokkcaz Posted September 12, 2006 Share Posted September 12, 2006 im making something that is somewhat like a blog ive made a table with the follow rowstexttimewhat other rows should i put in??? Quote Link to comment Share on other sites More sharing options...
mitzleah Posted September 12, 2006 Share Posted September 12, 2006 Here's my table structure for blog.CREATE TABLE `blog` ( `id` int(11) NOT NULL auto_increment, `display` tinyint(2) NOT NULL default '1', `archive` tinyint(2) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `entry` text NOT NULL, PRIMARY KEY (`id`), KEY `date` (`date`), KEY `archive` (`archive`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1 AUTO_INCREMENT=2 ;Hope this helps! Quote Link to comment Share on other sites More sharing options...
rallokkcaz Posted September 12, 2006 Author Share Posted September 12, 2006 thanks so what would the form for the post blog look like? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.