Posted By

Mat_ on 10/01/10


Tagged

sql date wp wordpres wpdb


Versions (?)

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


 / Published in: PHP
 

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

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

  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; ?>

Report this snippet  

You need to login to post a comment.