Jump to content


Photo

blog like thing im making


  • Please log in to reply
2 replies to this topic

#1 rallokkcaz

rallokkcaz
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts
  • LocationSomewhere, CA (Cactus Area)

Posted 12 September 2006 - 01:40 AM

im making something that is somewhat like a blog ive made a table
with the follow rows
text
time

what other rows should i put in???

#2 mitzleah

mitzleah
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationManila, Philippines

Posted 12 September 2006 - 01:45 AM

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!

#3 rallokkcaz

rallokkcaz
  • Members
  • PipPipPip
  • Advanced Member
  • 194 posts
  • LocationSomewhere, CA (Cactus Area)

Posted 12 September 2006 - 01:49 AM

thanks
so what would the form for the post blog look like?






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users