Yanik @ WP Page Numbers
- Alias: Yanik
- Skickat: 2010-03-27 @ 0:55
- Kommenterat: WP Page Numbers
Hello and thanks for your plugin, works great as long as I use a while but with a for loop it no longer works here is my code any help would be very welcome
Thanks
Yanik
posts wposts
LEFT JOIN $ec3->schedule wec3_schedule ON wposts.ID = wec3_schedule.post_id
LEFT JOIN $wpdb->term_relationships ON (wposts.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.taxonomy = ‘category’
AND $wpdb->term_taxonomy.term_id IN(4)
AND wec3_schedule.start >= CURDATE()
ORDER BY wec3_schedule.start ASC
”;
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>