Advanced Search

Return to Snippet

Revision: 32722
at October 1, 2010 23:37 by Mat_
Initial Code 
$myrows = $wpdb->get_results("
	SELECT wposts.post_title, wposts.ID , wpostmeta.meta_key, wpostmeta.meta_value 
	FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta 
	WHERE wposts.ID = wpostmeta.post_id 
	AND wposts.post_type = 'concerts'
	AND wpostmeta.meta_key = 'DateConcert' 
	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)."' 
	AND wposts.post_status = 'publish' 
	ORDER BY CAST(wpostmeta.meta_value AS DATE) ASC
	");
	if ($myrows) :
	foreach ($myrows as $post) :
		setup_postdata($post);
	?>
		<h2><a href="<?php the_permalink(); ?>" rel="bookmark"
			title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2>
	<?php
		endforeach;
	else :
	?>
		<h2> Not Found</h2>
	<?php endif; ?>
Initial URL 
http://www.kune-studio.com
Initial Description 
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
Initial Title 
Display wordpress posts with custom date meta value, ordered by this date,
Initial Tags 
sql, date
Initial Language 
PHP