leste
Forum Replies Created
-
The thing is that nowadays all new Delicious users have to register through Yahoo ID.
So you are pretty much closing the door on all the new delicious users who might be interested in using your plugin…
Forum: Fixing WordPress
In reply to: Sidebar widget for post authorsthanks for the quick reply, but this page explains how to display information about current author (the author of a given post), but i’m looking for a way to display a list of all authors posting on the blog…
Forum: Fixing WordPress
In reply to: Arrange Post Order?i’ve tried this:
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id)
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE $wpdb->term_taxonomy.term_id = $cat_ida
AND $wpdb->term_taxonomy.taxonomy = 'category'
WHERE $wpdb->postmeta.meta_key = 'views'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post'
ORDER BY ($wpdb->postmeta.meta_value + 0) DESC LIMIT 3,11;
";
but this doesnt work.. any hint ?
Forum: Fixing WordPress
In reply to: Arrange Post Order?here is a querystr im using:
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE $wpdb->postmeta.meta_key = 'views'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post'
ORDER BY ($wpdb->postmeta.meta_value + 0) DESC LIMIT 3,11;
";
I’d like to add a category condition but dont know how to add it… can anyone tell me please ?