mmlog

Unfortunately I haven’t found a solution yet. What I got working is:

$r = $wpdb->get_results(“SELECT SQL_CALC_FOUND_ROWS “.$wpdb->posts.”.* FROM “.$wpdb->posts.” WHERE 1=1 AND “.$wpdb->posts.”.post_type = ‘post’ AND (“.$wpdb->posts.”.post_status = ‘publish’) AND “.$wpdb->posts.”.post_date < ‘$post->post_date’ ORDER BY “.$wpdb->posts.”.post_date DESC LIMIT 0, $number”);

which displays post older than the current one. But the goal is to only display post older then the current one of the same category.

I have tried to extend the code like
$r = $wpdb->get_results(“SELECT SQL_CALC_FOUND_ROWS “.$wpdb->posts.”.* FROM “.$wpdb->posts.” wposts
LEFT JOIN $wpdb->postmeta wpostmeta ON wposts.ID = wpostmeta.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 1=1 AND wposts
.post_type = ‘post’ AND (wposts
.post_status = ‘publish’) AND wposts
.post_date < ‘$post->post_date’ ORDER BY wposts
.post_date DESC LIMIT 0, $number”);

(adapted from http://codex.ww.wp.xz.cn/Displaying_Posts_Using_a_Custom_Select_Query)

but it does not work. Any help to get it working is much appreciate.

Hello Michael, thanks for your help. Unfortunately it does not work as I want. Probably my request was too vague. Sorry for that. I will use a sample trying to explain what I want to achieve.

Lets says I have catagory1, there are 10 articles posted (latest created first):
– article10
– article9
– article8
– article7
– article6
– article5
– article4
– article3
– article2
– article1

If the user is on article9, links to article 8, 7, 6, 5, 4 should be available. If the user is on article5 -> 5, 4, 3, 2, 1 should be available.

Is this possible? I have read get_posts and WP_Query docu but did not find a clue. Any help much appreciated.

Gangleri, thanks for your comment.

I have to provide data from a third party (access via file system and database) on my website running with wordpress. Of course I want to use look & feel from the wordpress theme. So ‘data’ is no category nor a page within wordpress.

My problem is: How to tell wordpress, if example.org/data/file1 (or anything else in the example.org/data/ tree) is browsed, that it does not should search for a wordpress category. But instead, it should process the code I am providing in /wp-content/themes/mytheme/data.php

Any help much appreciated.