posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Dato'
AND STR_TO_DATE(wpostmeta.meta_value,'%d/%m/%Y') >= CURDATE()
AND wposts.post_status = 'publish'
AND wposts.post_type = 'post'
ORDER BY STR_TO_DATE(wpostmeta.meta_value,'%d/%m/%Y') ASC
LIMIT 3
";
$events = $wpdb->get_results($querystr, OBJECT);
if ($events):
foreach ($events as $post):
global $post;
setup_postdata($post); ?>
-
- Can't find any posts...