<?php
    require("config.inc.php");
    require("incfile/function.php");
    require("libs/Smarty.class.php");
    require("check_login.php");
     
    $classlist = array();
	$cid=isset($cid)?$cid:'';
	$classname="";
    $sql = "Select * from askclass order by displayorder";
    $result = mysql_query($sql) or die(mysql_error());
    while ($aclass = mysql_fetch_array($result)) {
        $classlist[] = $aclass;
        if ($cid == $aclass["classid"]) $classname = $aclass["classname"];
    }
     
     
    $questionlist = array();
    /*********分页参数计算部分*******************/
    $page = isset($_GET['page'])?intval($_GET['page']):1;
    $currpage = $page;
    $pagesize = 26;
    $sqlsss = '';
    if (!empty($cid)) $sqlsss = " and a.classid='$cid'";

    if (!empty($isclose)){
	$isclose=($isclose=="o")?0:1;
	$sqlsss .= " and a.islocked!='$isclose'";
     }

    $sql1 = "select count(*) from  ask as a where classid<>'' $sqlsss";
    $result = mysql_query($sql1) or die(mysql_error());
    $arr = mysql_fetch_array($result);
    $total = intval($arr[0]);
    if (intval($currpage) < 1)$currpage = 1;
    if (intval($currpage-1) * $pagesize > $total)$currpage = 1;
    if (($total % $pagesize) == 0)
    $totalpage = intval($total / $pagesize);
    else
        $totalpage = intval($total / $pagesize) + 1;
     
    $start_id = ($page-1) * $pagesize;
    // sql 之前 备注sql语句最后必须 是 limit $start_id,$pagesize ";
    /*********分页参数计算部分结束**************/
    $sql = "select a.*,c.classname from ask a, askclass c where a.classid=c.classid  $sqlsss  order by lastreptime desc limit $start_id,$pagesize";
  //   echo $sql;
    $reslut = mysql_query($sql) or die("error:detail.php,Can not Execute SQL");
    while ($question = mysql_fetch_array($reslut)) {
        $questionlist[] = $question;
    }
    $pageshow = pageshow($totalpage, $currpage, $filename."page", $halfPer = 5);
     
    $html = new Smarty;
    $html->left_delimiter = "<!--{";
    $html->right_delimiter = "}-->";
    $html->assign("seotitle", "专家答疑_长沙东方男科医院");
    $html->assign("pageshow", $pageshow);
    $html->assign("total", $total);
    $html->assign("cid", $cid);
    $html->assign("classname", $classname);
    $html->assign("adminuser", $adminuser);
    $html->assign("classlist", $classlist);
    $html->assign("list", $questionlist);
     
    $html->display('index.htm');

?>