我有3个与日期相关的元字段：
year = 2012release_date = 14 November 2012release_date_db = 20121114
我做了这个：
query_posts(\'meta_key=year&meta_value=2012&order=ASC&posts_per_page=7\');
release_date 或release_date_db?Order by meta values
1 个回复
SO网友:Abdussamad
只需查找release\\u date\\u db即可完成此操作：
function plugin_name_get_posts() {
global $wpdb;
$the_posts = $wpdb->get_results( "SELECT * FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id AND meta_key = \'release_date_db\' AND meta_value >= 20120000 AND meta_value <= 20121231 ORDER BY meta_value ASC;", ARRAY_A );
}
结束