Peter Boosten

Maybe it’s much easier than that: if your theme uses post_class() to fill the class for a post, then also a class exists per category.

This class can then be used to create some custom css for.

If you supply an URL, we could have a look.

Peter

My mistake: lose the urlencode().

echo "<a class='cssthingie' href='". get_permalink($post->ID) . "'>text in norwegian</a>";

Peter

oke, let’s examine this:

the equation is (previous_month + (year_of_previousmonth * 12)) should be equal to (current_month + (year_of_currentmonth * 12)) -1

For November if this year that would be:
11 + (2009 * 12) = 24119

December:
12 + (2009 * 12) = 24120

Which is exactly one more than November 🙂

Why this construct? Try to write a query for January, summing the values of December of the previous year.

So let’s examine the previous statement, since I might have gone wrong on the parenthesis and such, and I did, or so it seems (just before the first year function should be another parenthesis)

SELECT SUM($wpdb->postmeta.meta_value)
FROM $wpdb->postmeta, $wpdb->posts
WHERE $wpdb->postmeta.meta_key=’Meters’
AND $wpdb->postmeta.post_id=$wpdb->posts.id
AND (month($wpdb->posts.post_date) + (year($wpdb->posts.post_date) * 12)) = (month(now()) + (year(now()) * 12) – 1)

Peter

echo "<a class='cssthingie' href='". the_permalink() . "'>text in norwegian</a>";

Since you’re already in an php session (the echo command), you don’t need to start one again.

Peter

Apologies, had been occupied elsewhere…

//Connect to DB and calculate the sum of meters run in previous month
$meter_last_month = $wpdb->get_var($wpdb->prepare(“
SELECT SUM($wpdb->postmeta.meta_value)
FROM $wpdb->postmeta, $wpdb->posts
WHERE $wpdb->postmeta.meta_key=’Meters’
AND $wpdb->postmeta.post_id=$wpdb->posts.id
AND (month($wpdb->posts.post_date) + year($wpdb->posts.post_date) * 12)) = (month(now()) + (year(now()) * 12) – 1)”));

Peter

Have you checked if another template exists for this page, like pagename.php, page-slug.php or page-id.php (change pagename, slug and id accordingly)?

Since I actually have no idea where the page template is in the hierarchy, this could be the problem.

Peter

Well, it’s not really, you only need to get your query right:

you have to select the id’s from wp_posts where post_date matches your time frame, say a month, and use these id’s to select from the wp_postmeta table:

select sum(wp_postmeta.meta_value) from wp_postmeta,wp_posts where wp_postmeta.meta_key=’Meters’ and wp_postmeta.post_id=wp_posts.id and month(wp_posts.post_date)=12 and year(wp_posts.post_date)=2009;

Untested, but should do the trick.

EDIT: actually tested 🙂

Peter