yawnster

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter yawnster

    (@yawnster)

    Hi whooami,

    Thanks for the swift response, just the ticket!

    Thread Starter yawnster

    (@yawnster)

    Hey bud, thanks for the reply. I dont quite think I structured the question correctly.

    My Sidebar uses the function wp_get_archives(). I did a little digging, in that function it queries the post table and then returns the post_date as a month.. the line is..

    wp-includes/template-functions-general.php. Line 333.

    $arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM $wpdb->posts WHERE post_date < ‘$now’ AND post_date != ‘0000-00-00 00:00:00’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC” . $limit);

    from this i can see a function MONTH() around the post_date.. does anyone know where this function is defined because if im reading correctly it take the integer value from the database and converts it into the String value that it displays through the $text variable.

    Thanks Alex.

Viewing 2 replies - 1 through 2 (of 2 total)