Results 1 to 2 of 2

Thread: A database structure that works

  1. #1
    Join Date
    Jun 2010
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default A database structure that works

    Hey guys. I'm new to this forum. I apologize if what I am about to ask has already been asked but I haven't found it so far.

    I am going to be making daily posts on my website and I want to control through my own custom-built CMS. I've built a couple very simple ones before (ID, Post, Posted By) but the way I would like to organize this one has really got me stumped as far as the architecture of the database tables and I'd really like to learn.

    Naturally, I'd like to build it as dynamic as possible but without breaking the barrier of "simple". The actual page structure I'd like to work with is: Year > Month > Day. The URL's being like www.mywebsite.com/year/month/day

    As a basic example, I'd like to organize the PHP pages so if someone were to go to www.mywebsite.com/2010, they'd be greeted by a page that displays all of the active months that I posted entries within the year of 2010. If they chose "August", they'd be taken to www.mywebsite.com/2010/august and it would show all of the dates that I had posted that particular month. Finally, if they were to click the day of August 24, they would be greeted with the actual entry. The final URL being www.mywebsite.com/2010/august/24.

    Does this make sense? If so, does anyone have any idea how I can structure tables that will allow me to do this with as much ease as possible?

  2. #2
    Join Date
    May 2007
    Location
    Boston,ma
    Posts
    2,127
    Thanks
    173
    Thanked 207 Times in 205 Posts

    Default

    That sounds like what wordpress does. http://wordpress.org/
    Corrections to my coding/thoughts welcome.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •