while($rarray=@mysql_fetch_array($result))
{
$tp1->set_var("fangxing",$rarray["fangxing"]);
$tp1->set_var("suozaiqu",$rarray["suozaiqu"]);
$tp1->set_var("mianji",$rarray["mianji"]);
$tp1->set_var("jiage",$rarray["jiage"]);
$tp1->set_var("chaoxiang",$rarray["chaoxiang"]);
$tp1->set_var("jianzhutime",$rarray["jianzhutime"]);
$tp1->set_var("mdn",$rarray["mdn"]);
$tp1->parse("list","listqiu", true);
}这是那段代码,查询结果肯定不止一条。但显示出来就只有最后一条记录。怎么会事啊。晕。
命名太垃圾,不要笑我。

解决方案 »

  1.   

    require_once"template.inc";
    $html="e:\apache2\webroot\phpexample";
    $tp1=new template($html);
    $tp1->set_file("logn","qgouhtml.htm");
    $tp1->set_block("logn","listqiu","list"); $cid=@mysql_connect("localhost","root","123") or die ("connect failed")
    if(!isset($page))
    {
    $page=1;
    }
    $table='thouse';                                        
    $paixu='id';
    $pagesize=10;
    $start=(int)($page-1)*$pagesize;
    $sql="select fangxing,suozaiqu,mianji,jiage,chaoxiang,jianzhutime,mdn from $table where zushou='售' order by $paixu DESC limit $start,$pagesize";
    //echo $sql;
    $result=@mysql_db_query("housephp",$sql,$cid) or die("query failed");
    $rows=@mysql_num_rows($result);
    $pagecount=0;
    if($rows!=0)
    { if($rows<$pagesize)
    {
    $pagecount=1;
    }
    else
    {
    if($rows%$pagesize!=0)
    {
    $pagecount=(int)$rows/$pagesize+1;
    }
    else
    {
    $pagecount=$rows/$pgesize;
    }
    }

    }
    else
    {
    $pagecount=0;
    }$tp1->set_var("pnum",$pagecount);
    if($pagecount>1)
    {
    if($page<=1)
    {
    $tp1->set_var("down","下一页");
    }
    else
    {
    if($page>=$pagecount)
    {
    $tp1->set_var("up","上一页");
    }
    else
    {
    $tp1->set_var("up","上一页");
    $tp1->set_var("down","下一页");
    }
    }
    }
    /*while($rarray=@mysql_fetch_array($result))
    {
    $tp1->set_var("fangxing",$rarray["fangxing"]);
    $tp1->set_var("suozaiqu",$rarray["suozaiqu"]);
    $tp1->set_var("mianji",$rarray["mianji"]);
    $tp1->set_var("jiage",$rarray["jiage"]);
    $tp1->set_var("chaoxiang",$rarray["chaoxiang"]);
    $tp1->set_var("jianzhutime",$rarray["jianzhutime"]);
    $tp1->set_var("mdn",$rarray["mdn"]);
    $tp1->parse("list","listqiu",true);
    }*/
    /*while($rarray=@mysql_fetch_array($result))
    {
    $tp1->set_var(array("fangxing"=>$rarray["fangxing"],"suozaiqu"=>$rarray["suozaiqu"],"mianji"=>$rarray["mianji"],"jiage"=>$rarray["jiage"],"chaoxiang"=>$rarray["chaoxiang"],"jianzhutime"=>$rarray["jianzhutime"],"mdn"=>$rarray["mdn"],true));
    }*/
    $tp1->parse("list","listqiu");
    $tp1->parse("lognlogn","logn");
    $tp1->p("lognlogn");
    ?>