Custom values and categories

* bump *

(sorry for bumping)

/Jens

You mean custom field? If that’s the case, here’s some sample PHP…

This function can go in your theme’s functions.php, call it in a template where you need the list.

You’ll have to customize it as needed. And add a SQL clause to check the post category.

function my_custom_links() {
	global $wpdb;

	$querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
    WHERE wposts.ID = wpostmeta.post_id
    AND wpostmeta.meta_key = 'custom_field_key'
    AND (wpostmeta.meta_value = 'custom_value_1' OR wpostmeta.meta_value = 'custom_value_2')
    AND wposts.post_status = 'publish'
    AND wposts.post_type = 'post'
    ORDER BY wposts.post_title ASC
 	";

 	$postlist = $wpdb->get_results($querystr);
	if (! $postlist) return;
    	echo "<ul>";
  	foreach ($postlist as $fp) {
		$fp_id = $fp->ID;
		echo '<li><a href="' . get_permalink($fp_id) .
		     '" title="More about ' . $fp->post_title .
		     '">' . $fp->post_title . "</a><br />";
		echo '</li>';
 	}
  	echo '</ul>';
}

Thanks a lot, you are a very nice man! That did the trick, from here I can make it work they way I want.

/Jens

You’re most welcome. Don’t forget to set the forum thread to resolved…

By the way, I am in the process of switching from some custom fields to a new data table… if you plan to do any kind of complex search (such as on more than one custom field at a time) it might be better to use a database table.

Roger