$db_host = "localhost"; $db_name = "fourcelt_wp551"; //database name $db_user = "fourcelt"; //database user $db_pass = "Celtic000"; //user password $db_connection = @mysql_pconnect($db_host,$db_user,$db_pass) or die("Sorry, cannot connect to database."); @mysql_select_db($db_name,$db_connection) or die(dbdown()); ?>
$data = mysql_query("select
date_format(pm.meta_value,'%M %D @ %I:%i %p') as datetime,
p.ID,
p.post_title,
p.guid,
pm.post_id,
pm.meta_key,
pm.meta_value
from o1a_posts p join o1a_postmeta pm
on p.ID = pm.post_id
and date_sub(CURDATE(),INTERVAL 30 DAY) <= pm.meta_value
and pm.meta_key = '_EventStartDate'
order by p.ID limit 5");
//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo '‘.$result[‘post_title’].’‘;
echo “
“;
echo ‘‘.$result[‘datetime’].’‘;
echo “
“;
}
echo “
“;
echo “View All Events »“;
?>