WordPress.org

Support

Support » Plugins and Hacks » [Resolved] adding a WHERE 'x' >= 'y' to my WP_Query

[Resolved] adding a WHERE 'x' >= 'y' to my WP_Query

  • i’m using this to pull in my ‘events’ custom post type

    WP_Query('post_type=events&posts_per_page=10&meta_key=Date&orderby=meta_value&order=ASC&')

    but I want to add a WHERE clause so it only brings in dates that are in the future

    i’ve managed to kinda do it with this, but this only works in the ‘loop’

    <?php $recent = new WP_Query('post_type=events&posts_per_page=10&meta_key=Date&orderby=meta_value&order=ASC');
    
    if ($recent->have_posts()) :
    while($recent->have_posts()) : $recent->the_post(); 
    
    $fakedate = get_post_meta($post->ID, 'Date', true);
    list($y, $m, $d) = explode('/', $fakedate);
    $makedate = mktime(0, 0, 0, $m, $d, $y);
    $eventdate = strftime('%d %b %Y',$makedate);
    $checkdate = strftime('%Y%m%d ',$makedate);
    $todaysdate = date('Ymd'); 
    
    if ($checkdate >= $todaysdate) : ?>
    
      <a title="<?php the_title(); ?>" href="<?php the_permalink() ?>" rel="bookmark"><?php echo $eventdate; ?> - <?php the_title(); ?></a>
    
    <?php endif; ?>
    <?php endwhile; ?>
    <?php else : ?>
    
      <p>There are currently no events to display</p>
    
    <?php endif; ?>
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] adding a WHERE 'x' >= 'y' to my WP_Query’ is closed to new replies.
Skip to toolbar