|
|
|
connect();
//取出专题标题开始
$strQuery="select name from zhuanti where id=$zhuanti_id and flag='Y' order by id desc limit 0,1";
$db->query($strQuery);
if ($db->num_rows()!=0) {
$db->next_record();
list($zhuanti_name)=$db->Record;
}
//取出专题标题结束
//取出专题头条开始
$strQuery="select * from bginfo where zhuanti_id=$zhuanti_id and flag='Y' order by id desc limit 0,1";
$db->query($strQuery);
if ($db->num_rows()!=0) {
$db->next_record();
list($id,$zhuanti_id,$img_name,$img_pos,$bginfo,$title_id)=$db->Record;
}
if (trim($img_name)!="") {
$strBginfo="![](http://www.cheaa.com/img/newsimagepath/".$img_name;)
query($strQuery);
while ($db->next_record()) {
list($id,$column_name)=$db->Record;
$column_list[$id]=$column_name;
}
?>
|
|
|
query($strQuery);
//===取出数据===
$i=0;
while ($db->next_record() && $i<20) {
list($id,$title,$post_time)=$db->Record;
$show_time=substr($post_time,5,5); // $show_time=date("m-d",$post_time);
echo "· $title [$show_time]
";
$i++;
}
if ($db->num_rows()>20){echo " 更多... ";}
?>
|
|
