一个异常奇怪的问题：一刷新就异常，重新上传一下模板正常了，再刷新又异常。

php code

 $ms =& ms();

            $this->assign('set_avatar', $ms->user->set_avatar($id));

            $this->assign('user', $user);

            $this->assign('phone_tel', explode('-', $user['phone_tel']));

            /* 导入jQuery的表单验证插件 */

            $this->import_resource(array(

                'script' => 'jquery.plugins/jquery.validate.js'

            ));

			

			$page = $this->_get_page();

			 

			 //tixian code

			 $con = mysql_connect("localhost","a0527232048","abc");

    mysql_select_db("a0527232048",$con);

	$sql="select * from ecm_configs where id=1";

    $rows=array();

    $rows=mysql_query($sql,$con);

    while($row=mysql_fetch_array($rows))

     {

     $ct1=$row[10];//兑换条件最低积分

     $ct2=$row[11]; //兑换时间

     $ct3=$row[12]/100; //兑换比率

     }

	 

	 if ($jf1==0 and $jf2==0 and $jf3==0)

	 {

		 $sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons

FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id

WHERE 1 GROUP BY m.user_name

ORDER BY cons desc";

	 }

	 if ($jf1==0 and $jf2==0 and $jf3==1)

	 {

		 $sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons

FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id

WHERE 1 GROUP BY m.user_name

ORDER BY cons desc) as t where cons>=".$ct1."";

	 }

	 if ($jf1!==0 and $jf2!==0 and $jf3==2)

	 {

		 $sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons

FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id

WHERE 1 GROUP BY m.user_name

ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";

	 }

	 

	 $rows2=mysql_query($sql2,$con);

	 $lists=array();

	 $page['item_count'] = mysql_num_rows($rows2);

	 while($row2=mysql_fetch_row($rows2))

	 {

		$username=$row2[0];

		$jifen=$row2[1];

		$mon=$jifen*$ct3;

		$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";

	 }

			 //tixian code end 

        $this->_format_page($page);

        $this->assign('page_info', $page);

			//$this->assign('cftj',zdcfjf($id));

			$this->assign('txlist',$sql2);

            $this->display('user.tixian.html');

user.tixian.html 代码

<table class="tab1">

<tr><td width="50" align="center"><strong>ID</strong></td><td width="100" align="center"><strong>用户</strong></td><td width="100" align="center"><strong>财富积分</strong></td><td width="350" align="center"><strong>可提现金额</strong></td><td width="100" align="center"><strong>操作</strong></td></tr>

{foreach from=$txlist item=txlist }

{$txlist}

{/foreach}

</table>

程序做好后，第一次浏览页面，是正常的，能调出符合条件的N条记录；
可刷新一次，就异常了，只能调了一条记录，异常的时候打印$sql2也是正常的，把异常时候的$sql2语句放到phpmyadmin执行的结果是正常的；

这个时候 ，再上传一次 user.tixian.html 刷新一次的时候是正常的，再刷新一次，又出现上面的异常；

再上传 user.tixian.html 又正常，再刷新，又异常。。。

这中间我也注意观察了服务器上的user.tixian.html 没有自己更改过，也不可能自己更改吧这模板文件？


折磨了一晚上了，请帮忙看看，谢谢。