$sql = " FORCE INDEX (dateline) ORDER BY dateline DESC LIMIT 0,5";
} else {
$sql = ' '.trim($network['doing']);
}*/
$query = $_SGLOBAL['db']->query("SELECT * FROM ".tname('doing').",".tname('tagspace')." WHERE ".tname('doing.uid')." = ".tname('tagspace.uid')." and ".tname('tagspace.tagid')." = '$tagid' order by dateline DESC LIMIT 0,10");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
$netcache['doinglist'][] = $value;
}
//相册
$netcache['albumlist'] = array();
$query = $_SGLOBAL['db']->query("SELECT * FROM ".tname('album').",".tname('tagspace')." WHERE ".tname('album.uid')." = ".tname('tagspace.uid')." and ".tname('tagspace.tagid')." = '$tagid' order by updatetime DESC LIMIT 0,8");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {