get_month_link() question

Hey all –

I’m trying to do a “month by meta” url list, the idea is based upon this post here in the forums.

I believe I’m getting the query correct, because when I echo after each step, then my output is doing what it should be doing. What I have right now is this:

} elseif ( 'catmonthly' == $type ) {
      $arcresults = $wpdb->get_results("SELECT DISTINCT
 $wpdb->postmeta.meta_value AS date, count(ID) as posts FROM $wpdb->posts, $wpdb->post2cat, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.post_id = $wpdb->postmeta.post_id AND $wpdb->post2cat.category_id = '$mcat' AND $wpdb->postmeta.meta_key='newsletter_month_year' AND $wpdb->posts.post_type = 'post' AND $wpdb->posts.post_status = 'publish' GROUP BY $wpdb->postmeta.meta_value ORDER BY meta_value DESC");

      if ( $arcresults ) {
        $afterafter = $after;
        foreach ( $arcresults as $arcresult ) {
          $date = $arcresult->date;
          list($month, $year) = split(' ', $date);
          //test line - uncomment to test
          //echo $month . " " . $year . "<br />";
          $url = get_month_link($year,$month) . "?cat=" .$mcat;
          $text = sprintf(__('%1$s %2$d'), $wp_locale->get_month($month), $year);
          if ( $show_post_count )
            $after = ' ('.$arcresult->posts.')' . $afterafter;
          echo get_archives_link($url, $text, $format, $before, $after);
        }
      }
    }

So, when you get to the “list(split…)” line, I’ve put in a test line right after it that echoes out the $month and $year – just a quickie test to be sure the correct output is being generated. According to the echo statement, it is – it’s outputting the correct $month and $year every time. However…

the very next line is:

$url = get_month_link($year,$month) . "?cat=" .$mcat;

Now, since the test echo statement says the correct info is being parsed as $month and $year, it stands to reason that the “$year,$month” part in the “get_month_link()” area would snap up these correct values – but they are not. $year comes through just fine, but $month is ignored for some reason. So when my links list comes through, it lists the year, but no month. I basically have a list of links that all say “2007”, and each one is linked to “domain.com/2007/00/?cat=13”.

Would anyone know why this is? It really doesn’t make any sense to me, since it’s echoing the values correctly *just* before the get_month_link()…so I don’t know why it’s not coming through to the next few areas.