0) $sql .= " AND contentgroup.Id IN ( select contentgroup from category_contentgroup WHERE websiteid=17 AND category = '$cat') "; $sql .= " ) GROUP BY contentgroup.Id, contentgroup.Id ORDER BY DTE DESC LIMIT " . (($page - 1) * $per_page) . ', ' . $per_page . " "; $updates = $mc->get($memcache_key.md5($sql)); $updates_all = $mc->get($memcache_key."_all".md5($sql)); if(empty($updates) or empty($updates_all)){ $updates = array(); $res = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { list($row['photos'], $row['movie_length']) = get_photo_movie_info($row['PreviewXML_PHP']); $updates[] = $row; } $mc->set($memcache_key.md5($sql), $updates, MEMCACHE_COMPRESSED, 3600*24); $sql1 = $sql; $sql = 'SELECT FOUND_ROWS()'; $maxrows = mysql_fetch_row(mysql_query($sql)); $updates_all = $maxrows[0]; $mc->set($memcache_key."_all".md5($sql1), $updates_all, MEMCACHE_COMPRESSED, 3600*24); } $paging_line = cool_paging('tour.php?cat='.$cat.'&p=', $page, $per_page, $updates_all); ?> Welcome to !
    $value){ ?>
  • 0) echo round($value['movie_length'] / 60, 0).":00 min video, "; ?> 0) echo $value['photos']." photos"; ?>