Support

October 14, 2013 at 2:57 am

Hi,

The $pastevent is an array of the event details, so you can echo/add $pastevent->start_date

eg

<?php
/*
Template Name: Past Events
*/
?>
<ul>
<?php 
global $wpdb;
$tablename = $wpdb->prefix . events_detail;
$pastevents = $wpdb->get_results("SELECT * FROM $tablename WHERE start_date < curdate() AND event_status <> 'D' ");
 foreach ( $pastevents as $pastevent ){
 echo '<li><a href="' . espresso_reg_url($pastevent->id) . '">' . stripslashes($pastevent->event_name) . ' - ' . $pastevent->start_date . '</a></li>';
 }
?>
</ul>

I haven’t tested it, but you will probably need to reformat the date as it is likely to spit it out like 2013-10-14.

date(‘d-m-Y’, $pastevent->start_date) should work, see here for more info http://php.net/manual/en/function.date.php

October 14, 2013 at 11:22 am

php date() needs a string or a timestamp in order to work. In this case you can use date_create and date_format. Here’s a revised loop that displays the date using date_create and date_format:

foreach ( $pastevents as $pastevent ){
 	$my_event_date = date_create($pastevent->start_date);
 	echo '<li><a href="' . espresso_reg_url($pastevent->id) . '">' . stripslashes($pastevent->event_name) . ' - ' . date_format($my_event_date, 'F j, Y' ) .'</a></li>';
 }