WordPress.org

1. karl19
   Member
   Posted 4 months ago #

   Hello,

   We've got a collection of pages which can have multiple custom dates and locations, saved as custom fields; these are our site's course listings, hence why a page can have multiple meta_values for the same meta_key.

   We would like to display a list of the next five courses to run and managed to do this with a select query. What we're not managing, however, is to retrieve the correct date for each listing. The list might be something like this:

   Course 1
   Course 2
   Course 1
   Course 3
   Course 2

   Using <?php echo get_post_meta($post->ID, 'startdatum', true); ?> only returns the first (earliest) meta_value, hence both listings for "Course 1" get the same date.

   Is there a way to get the "correct" date for a course? The query manages to sort the pages by a specific meta_value, and I'd then like to echo this specific value that is used for sorting, not the first meta_value. Perhaps one can iterate somehow, so that if the query outputs the page a second time, then it'll use the second meta_value? Of course, then there is the problem of old dates still attached to the page..

   I'm not sure if there is a way, with the help of a "normal" select query. I should mention that we're using the Flutter plugin to add dates (group of start date, end date and location), maybe the only way is to use some Flutter-specific code.

   I'll post back if I come up with a solution.

   *****

   <?php
   
   	$querystr = "
   		SELECT wposts.*
   		FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
   		WHERE wposts.ID = wpostmeta.post_id
   		AND wpostmeta.meta_key = 'startdatum'
   		AND wpostmeta.meta_value > NOW()
   		AND wposts.post_status = 'publish'
   		AND wposts.post_type = 'page'
   		ORDER BY wpostmeta.meta_value ASC
   		LIMIT 5
   	";
   
    $pageposts = $wpdb->get_results($querystr, OBJECT);
   
    ?>
   
    <?php if ($pageposts): ?>
    <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post); ?>
   
    <a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a><br />
    <?php echo get_post_meta($post->ID, 'startdatum', true); ?>
   
    <?php endforeach; ?>
    <?php else : ?>
       <h2 class="center">Not Found</h2>
       <p class="center">Sorry, but you are looking for something that isn't here.</p>
    <?php endif; ?>

2. karl19
   Member
   Posted 3 months ago #

   In the end we had someone help us figure this out. It might be that the solution is only suitable if you're using the Flutter plugin, I'm not entirely sure, perhaps any custom field is fine.

   Below is the code, perhaps it can help someone.

   <?php
   //Get today date
   $today = strtotime("now");
   
   //Revised query string
   $querystr = "
   	SELECT wposts.*
   	FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
   	WHERE wposts.ID = wpostmeta.post_id
   	AND wpostmeta.meta_key = 'startdatum'
   	AND wpostmeta.meta_value > '" . date("Y-m-d", $today) . "'
   	AND wposts.post_status = 'publish'
   	AND wposts.post_type = 'page'
   	ORDER BY wpostmeta.meta_value ASC
   	LIMIT 0, 3
   ";
   
   $dateIndexes = array();
   $pageposts = $wpdb->get_results($querystr);
   ?>
   
   <?php if ($pageposts): ?>
   <ul>
   <?php foreach ($pageposts as $post): ?>
   <?php setup_postdata($post);?>
   
   	<li><a href="<?php the_permalink() ?>"><b><?php the_title(); ?></b><br />
   	<?php
   		//Get start date value
   		$startdate_values = get_post_custom_values('startdatum');
   		$startdate_values_copy = $startdate_values;
   		$start = 0;
   
   		if (strlen($dateIndexes[$post->ID]) > 0 && $dateIndexes[$post->ID]>=0)
   		{
   			$start = $dateIndexes[$post->ID]+1;
   		}
   
   		$location_values = get_post_custom_values('ort');
   
   		sort($startdate_values);
   		for ($i=$start; $i< count($startdate_values); $i++)
   		{
   			//Convert to date as it is stored as string in database
   			$nextdate = strtotime($startdate_values[$i]);
   
   			//Check if the date equals or greater than today
   			if ($nextdate>=$today)
   			{
   				//Print out
   				echo strftime('%e %b, %Y', $nextdate);
   
   				$index = -1;
   				//Find the right index before sortig
   				for ($j=$start; $j< count($startdate_values_copy); $j++)
   				{
   					if ($startdate_values_copy[$j] == $startdate_values[$i])
   					{
   						$index = $j;
   						break;
   					}
   				}
   
   				//Put into an array
   				$dateIndexes[$post->ID] = $i;
   
   				//If found, break the loop
   				break;
   			}
   		}
   	?></a></li>
   
   <?php endforeach; ?>
   </ul>
   <?php else : ?>
   <p>No upcoming events</p>
   <?php endif; ?>

Reply

You must log in to post.