cat.REF_MODULE_ID = $MID AND cat.flag = 0 AND cat.CONTENT_CAT_ID = $CID AND content.SUB_CAT_ID = $SID AND content.APPROVE_FLAG = 'Y' AND content.CONTENT_STATUS_FLAG = 0 AND content.CONTENT_ID = $NID ORDER BY content.ORDER_DATA desc "; $query = mysql_query($sql, $conn); $num_rows = mysql_num_rows($query); $row = mysql_fetch_array($query); $date = ConvertBoxDate($row['EVENT_START_DATE']); $dateEnd = ConvertBoxDate($row['EVENT_END_DATE']); ?> <div class="box-newsdetail-main"> <div class="box-slide-big"> <div id="sync1" class="owl-carousel"> <?php $audioPlayer = false; $thumbRender = "\n\n\t"; $extraStyle = ""; $getPicSql = "SELECT * FROM trn_content_picture WHERE CONTENT_ID = ".$CONID." AND CAT_ID = ".$CID." AND ( DIV_NAME != 'Other' OR DIV_NAME IS NULL ) ORDER BY DIV_NAME ASC , ORDER_ID ASC"; $rsPic = mysql_query($getPicSql) or die(mysql_error()); $rowPicturecount = mysql_num_rows($rsPic); if ($rowPicturecount == 1) { $extraStyle = " style='display:none;'";
AND content.CONTENT_STATUS_FLAG = 0 AND content.SUB_CAT_ID = " . $museumDataNetworkNewsSubCat . " ORDER BY EVENT_START_DATE ASC LIMIT 0, 6"; $query = mysql_query($newsSql, $conn) or die($newsSql); $index = 1; while ($row = mysql_fetch_array($query)) { $gap = ""; if ($index == 2) { $gap = " mid "; } $date = ConvertBoxDate($row['EVENT_START_DATE']); /*social*/ $path = 'mdn-news-detail.php?MID=' . $MID . '%26CID=' . $CID . '%26SID=' . $row['SUB_CAT_ID'] . '%26CONID=' . $row['CONTENT_ID'] . ''; $fullpath = _FULL_SITE_PATH_ . '/' . $path; $redirect_uri = _FULL_SITE_PATH_ . '/callback.php?p=' . $row['CONTENT_ID']; $fb_link = 'https://www.facebook.com/dialog/share?app_id=' . _FACEBOOK_ID_ . '&display=popup&href=' . $fullpath . '&redirect_uri=' . $redirect_uri; $path = str_replace("%26", "&", $path); $title = htmlspecialchars(trim($row['CONTENT_LOC'])); $detail = strip_tags(trim($row['CONTENT_BRIEF'])); /*social*/ if ($index == 4) echo '<hr class="line-gray"/>'; echo '<div class="box-tumb cf' . $gap . '">';