posts wposts, $wpdb->postmeta wpostmeta, $wpdb->term_relationships category
WHERE wposts.ID = category.object_id
AND category.term_taxonomy_id = 4
AND wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Aktuala galerija'
";
$pageposts = $wpdb->get_results($querystr, OBJECT);
if ($pageposts):
foreach ($pageposts as $post):
setup_postdata($post); ?>
Arhīvs
posts wposts, $wpdb->postmeta wpostmeta, $wpdb->term_relationships category
WHERE wposts.ID = category.object_id
AND category.term_taxonomy_id = 11
AND wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Makslas veids'
ORDER BY wpostmeta.meta_value DESC
";
$pageposts = $wpdb->get_results($querystr, OBJECT);
$startingyear = '';
if ($pageposts):
foreach ($pageposts as $post):
setup_postdata($post);
$year = strtoupper(substr(get_post_meta($post->ID,'Makslas veids',true),0,1)).substr(get_post_meta($post->ID,'Makslas veids',true),1);
if($year<>$startingyear){ if($startingyear!='') echo ''; echo '
- '.$year.'
';$startingyear=$year;};
?>
-