get_results($sql_fet_evt22);
if(count($rst_fet_evt22) > 0)
{
foreach ($rst_fet_evt22 as $page_22)
{
$newid= $page_22->ID;
$newid222= $page_22->ID;
//PICK IMAGE ID
$sql_pckimg = "Select meta_value from `wp_postmeta` where meta_key='_thumbnail_id' and `post_id` = '$newid222'";
$results_pckimg = $wpdb->get_results($sql_pckimg,'ARRAY_A');
$newimgid= $results_pckimg[0]['meta_value'];
//PICK IMAGE PATH
$sql_pckimg2 = "Select guid from `wp_posts` where `ID` = '$newimgid'";
$results_pckimg2 = $wpdb->get_results($sql_pckimg2,'ARRAY_A');
$newimgpath= $results_pckimg2[0]['guid'];
$sng_fet_name22_org = $page_22->post_title ;
$sng_fet_content22 = $page_22->post_content;
/*$sng_fet_content22 = preg_replace('/
]+./','',$sng_fet_content22);
$sng_fet_content22 = substr($sng_fet_content22 , 0, 210);
$last_space2 = strrpos(substr($sng_fet_content22, 0, 210), ' ');
$sng_fet_content22 = strip_tags($sng_fet_content22);
*/ $sng_fet_content22= substr($sng_fet_content22 , 0, 110);
$last_space2 = strrpos(substr($sng_fet_content22, 0,110), ' ');
$sng_fet_content22 = strip_tags($sng_fet_content22);
$sng_fet_content22 = substr($sng_fet_content22, 0, $last_space2);
if(strlen($sng_fet_content22)>1)
{
$sng_fet_content22=substr($sng_fet_content22,0,110);
strlen($sng_fet_content22);
$res=explode(".",$sng_fet_content22);
count($res);
if(count($res) > 1)
{
//echo "";
//print_r($res);
for($i=0; $iget_results($sql_pcktime,'ARRAY_A');
$event_timestampdate= $results_pcktime[0]['meta_value'];
$event_time= date("g:iA", $event_timestampdate);
$splitTimeStamp = explode(" ",$event_timestampdate);
$date = $splitTimeStamp[0];
$time = $splitTimeStamp[1];
$timenew = $splitTimeStamp[1];
//VENUE ADDRESS id
$sql_pckven = "Select meta_value from `wp_postmeta` where meta_key='_EventVenueID' and `post_id` = '$newid'";
$results_pckven = $wpdb->get_results($sql_pckven,'ARRAY_A');
$newgetId= $results_pckven[0]['meta_value'];
//VENUE ADDRESS
$sql_pckven2 = "Select meta_value from `wp_postmeta` where meta_key='_VenueAddress' and `post_id` = '$newgetId'";
$results_pckven2 = $wpdb->get_results($sql_pckven2,'ARRAY_A');
$VenueAddress= $results_pckven2[0]['meta_value'];
//VENUE NAME
$sql_pckven3 = "Select meta_value from `wp_postmeta` where meta_key='_VenueVenue' and `post_id` = '$newgetId'";
$results_pckven3 = $wpdb->get_results($sql_pckven3,'ARRAY_A');
$Venue_name= $results_pckven3[0]['meta_value'];
//Select _VenueAddress,_VenueVenue from `wp_postmeta` where meta_key='_EventVenueID' and `post_id` = '$newgetId'
//$date= date("F j, Y", $date);
$time= date("g:iA", $time);
?>
VIEW ALL EVENTS
