tcushing

Thank you, I added the semicolon as such by still not showing content. If you have any other suggestions I would be grateful.

<div class="entry">
       <?php the_content(__('More...'));  ?>
    </div>
     </div>

I want to put a space between each event like a ‘br’ or ‘<p>’ so that the events are not listed so close to each other.

Any help you can throw my way would be greatly appreciated!

Awesome! I got it. Thanks!

If I enter the data as 11/30/2010. My posts do not appear. I am using the following code to select particular posts and order them:

$querystr = "

    SELECT wposts.*

    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta

    WHERE wposts.ID = wpostmeta.post_id

    AND wposts.post_status = 'publish'

    AND wposts.post_type = 'post'

    AND wpostmeta.meta_key = 'upcomingeventdate'

    AND wpostmeta.meta_value > NOW()   

    ORDER BY wpostmeta.meta_value asc

 ";

Thanks! I’ll chip away at it!

Awesome, thanks!

One more question – can you please direct me to where I can find out how to set the ORDER BY to a post tag for the code below instead of the meta value:

<?php

 $querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
    WHERE wposts.ID = wpostmeta.post_id
    AND wposts.post_status = 'publish'
    AND wposts.post_type = 'post'
    AND wpostmeta.meta_key = 'mathdate'
    AND wpostmeta.meta_value > NOW()
    ORDER BY wpostmeta.meta_value desc
 ";
 $pageposts = $wpdb->get_results($querystr, OBJECT);
?>
<?php if ($pageposts): ?>
  <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post_title); ?>
    <li><a href="<?php the_permalink(); ?>"><?php the_title();
?></a></li>
 <?php endforeach; ?>
<?php endif; ?>