Web Analytics Made Easy -
StatCounter Archiving my Blog - CodingForum

Announcement

Collapse
No announcement yet.

Archiving my Blog

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Archiving my Blog

    Need a little help here

    Here is my problem. For every blog entry, I insert the current month into the database. From there, I want to archive them so I can go like

    SELECT month,field,field,field FROM blog WHERE month='February'

    The problem is that I don't want to list every month. Only months that are currently in the databse. i.e. Don't show up May, if there is no entry for May. I hope I am being clear. How might I go about doing this?

    Thanks
    Stevie Peele
    Neverside IRC Network - irc.veonex.net | tc.tutorialnetwork.org
    #dev - any programming,etc. question
    #design - design discussion and critque
    #central - general chat
    Come join us!

  • #2
    "select distinct month from table"

    then use that to build your select box.
    "To be successful in IT you don't need to know everything - just where to find it in under 30 seconds"

    (Me Me Me Me Me Me Me Me Me)

    Comment


    • #3
      Works great, so far at least

      Thanks
      Stevie Peele
      Neverside IRC Network - irc.veonex.net | tc.tutorialnetwork.org
      #dev - any programming,etc. question
      #design - design discussion and critque
      #central - general chat
      Come join us!

      Comment

      Working...
      X