Forums

Archive (5 posts)

  1. BooBooBear
    Member
    Posted 3 years ago #

    Everytime someone posts a comment it goes into the January 2008 archive (the month and year I started with WordPress).

    I'd like the posts to go in their respective Month/Year archive folder. Obviously if someone posts today I'd like it in the July 2008 archive.

    Can someone shed light on this for me?

  2. BooBooBear
    Member
    Posted 3 years ago #

    Still looking for help on this. Anyone?

  3. Anonymous
    Unregistered
    Posted 3 years ago #

    Hello, I'm using the plugin "Compact Archives" and I need to make a modification to filter the wordpress Archivem and that it only shows a certain category (ID4).

    What do I need to modify in this mySQL script?
    *******************************************
    if ($below21) {
    $now = current_time('mysql');
    $results = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month FROM " . $wpdb->posts . " WHERE post_date <'" . $now . "' AND post_status='publish' AND post_password='' ORDER BY year DESC, month DESC");
    } else {
    $results = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month FROM " . $wpdb->posts . " WHERE post_type='post' AND post_status='publish' AND post_password='' ORDER BY year DESC, month DESC");
    }

    ******************************

    Thanks in advance!

  4. moshu
    Member
    Posted 3 years ago #

    Just don't double post - duplicate posts get deleted quickly.

  5. moshu
    Member
    Posted 3 years ago #

    aurielito,

    Are you insane? You already posted this in ten different topics. STOP it!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags