Results 1 to 4 of 4

Thread: Weblog archives

  1. #1
    Join Date
    Oct 2005
    Posts
    2

    Unanswered: Weblog archives

    I'm trying to display archives from a database.

    Here's an example of what I want: http://publicaddress.net/archive,hardnews.sm

    Here's what I have at the moment: http://killjim.com/archives.php

    I just some kind of loop to add the entries for each month. Can anyone help?

    I'm using 'group by'.

    My MySQL version is 4.0.18.

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Crystal ball broken today. Could you explain what you are trying to do in terms of the database?

  3. #3
    Join Date
    Oct 2005
    Posts
    2
    I'm trying to display a bunch of entries from the database under each month.

    Month
    Entry
    Entry
    Entry
    Entry
    Entry

    Month
    Entry
    Entry
    Entry

    Just like the link a gave above.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you don't want GROUP BY, you want ORDER BY

    then do the formatting in your application layer
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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