Display wordpress posts with custom date meta value, ordered by this date,


/ Published in: PHP
Save to your folder(s)

First you have to add a custom value with a correct date format.
The lines:
`AND CAST(wpostmeta.meta_value AS DATE) > '".date("Y-m-d H:i:s")."'
AND CAST(wpostmeta.meta_value AS DATE) < '".date("Y-m-d H:i:s", $date2)."' `
are only used to select dates between the current day and 2 months later


Copy this code and paste it in your HTML
  1. $myrows = $wpdb->get_results("
  2. SELECT wposts.post_title, wposts.ID , wpostmeta.meta_key, wpostmeta.meta_value
  3. FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
  4. WHERE wposts.ID = wpostmeta.post_id
  5. AND wposts.post_type = 'concerts'
  6. AND wpostmeta.meta_key = 'DateConcert'
  7. AND CAST(wpostmeta.meta_value AS DATE) > '".date("Y-m-d H:i:s")."'
  8. AND CAST(wpostmeta.meta_value AS DATE) < '".date("Y-m-d H:i:s", $date2)."'
  9. AND wposts.post_status = 'publish'
  10. ORDER BY CAST(wpostmeta.meta_value AS DATE) ASC
  11. ");
  12. if ($myrows) :
  13. foreach ($myrows as $post) :
  14. setup_postdata($post);
  15. ?>
  16. <h2><a href="<?php the_permalink(); ?>" rel="bookmark"
  17. title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>
  18. <?php
  19. endforeach;
  20. else :
  21. ?>
  22. <h2> Not Found</h2>
  23. <?php endif; ?>

URL: http://www.kune-studio.com

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.