Hello Developer,
\nI have two running wp site in a same database and in one of them I’ve setup your event plugin.<\/p>\n
I’ve added the code below to get the same events on other site pulling out directly from the database, so I add events just one time.<\/p>\n
I would like to ask you how can i add the start date on the event and how i have to improve the sql code.<\/p>\n
When I’ve added the StartDate value from the table eo_events i get duplicated results.
\nFor example, every dates is present, it’s attacched for every single event.<\/p>\n
I know it’s a bit tricky but I hope you can help me.
\nThanks a lot<\/p>\n
$mydb = new wpdb('user','pass','database','host');\n$events = $mydb->get_results("SELECT post_title, post_name, StartDate FROM wp_posts, eo_events WHERE post_type = 'event'");\n\nforeach ($events as $obj) : ?>\n<div id="<?php echo $obj->post_id; ?>" class="fusion-one-third one_third fusion-layout-column fusion-column spacing-yes post">\n <div class="fusion-date-and-formats">\n <div class="fusion-date-box updated">\n <span class="fusion-date">\n <?php echo date('j', strtotime($obj->StartDate)); ?><\/span>\n <span class="fusion-month-year">\n <?php\n setlocale(LC_ALL, 'it_IT');\n echo strftime('%b %Y', strtotime($obj->StartDate));\n ?><\/span>\n <\/div>\n <div class="fusion-format-box"><i class="fa fa-calendar"><\/i><\/div>\n<\/div>\n <div class="fusion-post-content post-content">\n <h2 class="entry-title">\n <a target="_blank" href="<?php echo $obj->post_name; ?>"><?php echo $obj->post_title; ?><\/a>\n <\/h2>\n <\/div>\n<\/div>\n\n<? endforeach; ?><\/code><\/pre>\nscreenshot:
\ncurrently I’ve just six events, look how many i get \ud83d\ude41
\n[IMG]http:\/\/i57.tinypic.com\/209fz8g.png[\/IMG]
\nscreenshot<\/a><\/p>\nhttps:\/\/wordpress.org\/plugins\/event-organiser\/<\/p>\n","protected":false},"template":"","class_list":["post-6178698","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-events","topic-tag-mysql","topic-tag-php","topic-tag-query"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6178698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6178698\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=6178698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![screenshot<\/a><\/p>\nhttps:\/\/wordpress.org\/plugins\/event-organiser\/<\/p>\n","protected":false},"template":"","class_list":["post-6178698","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-events","topic-tag-mysql","topic-tag-php","topic-tag-query"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6178698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6178698\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=6178698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"http:\/\/i57.tinypic.com\/209fz8g.png\"){kind=link}