get_results($sql_fet_evt22); if(count($rst_fet_evt22) > 0) { foreach ($rst_fet_evt22 as $page_22) { $newid= $page_22->ID; $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, 90)."..."; $sng_fet_content223 = strip_tags($sng_fet_content22); //DATE TIME $sql_pcktime = "SELECT * FROM `wp_postmeta` WHERE `post_id` = '$newid' and meta_key='_EventStartDate'"; $results_pcktime = $wpdb->get_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]; //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); //PICK IMAGE ID $sql_pckimg = "Select meta_value from `wp_postmeta` where meta_key='_thumbnail_id' and `post_id` = '$newid'"; $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']; ?>

READ MORE