bex_00

Forum Replies Created

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

  • Ok, that didn’t work. I’m still getting that error. I’m going to post what I did why my code as instructed above, what is wrong with this code???
    [long code moderated]

    I changed this line of code that goes on the sidebar from:

    $catmnthquery=(“type=catmonthly&mcat=” .$cat);

    to:

    $catmnthquery=($cat);

    It seem to work good.

    It sounds great. I would like to implement it, but I’m getting this error. I was wondering if I could get some help. Thanks a lot!

    WordPress database error: [You have an error in your SQL syntax near ‘AND post_date != ‘0000-00-00 00:00:00’ AND post_status = ‘publish’ GROUP BY YEAR’ at line 1]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts, wp_post2cat WHERE post_date < ‘2006-06-18 17:37:11’ AND category_id = 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

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