{dede:php}
// 分页处理
$pagesize = 2; // 页面显示记录数；
$sql = 'select a.title,a.litpic,z.expert,d.level,d.titles,d.resume from dede_archives as a,dede_addonzjtb as z,dede_addondocter as d where a.id = z.aid and z.expert = d.name AND a.litpic is not null GROUP BY a.title';
$db->SetQuery($sql);
$db->Execute();
$index = 1;
while($arr = $db->GetArray()) {
$resume = mb_substr($arr["resume"],0,115,'gbk'); // 不用substr()函数是因为它把中文给截断，成乱码；
echo '<div class="new_nl1" style="color:#333;">';
echo ' <div class="new_nl1_l left">第';
echo ' <br />';
echo ' <span>'.$index.'</span>';
echo ' <br />期';
echo ' </div>';
echo ' <div class="new_nl1_c left">';
echo ' <a href="/" target="_blank">';
echo ' <img src="'.$arr["litpic"].'" />';
echo ' </a>';
echo ' </div>';
echo ' <div class="new_nl1_r left">';
echo ' <h2><a href="/" target="_blank">'.$arr["title"].'</a></h2>';
echo ' <h3>解答专家：<strong>'.$arr["expert"].' '.$arr["level"].'</strong></h3>';
echo ' <p><strong>[专家简介]</strong>：'.$arr["titles"].'</p>';
echo ' <p>'.$resume.'...<a href="/" class="red" target="_blank">[查看详细]</a>';
echo ' </p>';
echo ' <h5><a href="#" target="_blank">我要咨询糖尿病专家</a></h5>';
echo ' </div>';
echo ' </div>';
$index++;
}
{/dede:php}
