WordPress post type “event” query string fix?

Question

What am I doing wrong in this query? I want to select events from a custom post type called events and order by the event date and only show ones after the current date. It doesn't seem to work...

$querystr = "

SELECT $wpdb->posts.* 
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id 
AND $wpdb->postmeta.meta_key = 'wpcf-start-date'
AND $wpdb->postmeta.meta_value >= CURDATE() 
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'events'
ORDER BY $wpdb->postmeta.meta_value ASC

"; 

Answer 1

Your date format is wrong, MySQL date format is yyyy-mm-dd. Once you get that fixed, see WP_Query's meta_query, no need for raw SQL in this case.