这里有问题:
_______________________________________________
//增加条件
function addCondition($str_table,$str_con)
{
$sqlstr="SELECT * FROM $str_table";
$temp_rs=mysql_query($sqlstr);
if(mysql_errno()>0)
{
echo "发生错误!\n$sqlstr";
exit;
}
$temp_row=mysql_fetch_array($temp_rs);
//************************************************ $this->recordcount=$temp_row[0];//这里如果有数据的话,结果为1;而不是记录总数//************************************************
$this->pagecount=ceil($this->recordcount/$this->pagesize);
if($this->cpage<1){$this->cpage=$this->pagecount;}
if($this->cpage>$this->pagecount){$this->cpage=1;}
$temp_abslocate=($this->cpage-1)*$this->pagesize;
$this->sql_limit=" LIMIT ".$temp_abslocate.",".$this->pagesize;
$this->prepage=$this->cpage-1;
$this->nextpage=$this->cpage+1;
}
_______________________________________________
//增加条件
function addCondition($str_table,$str_con)
{
$sqlstr="SELECT * FROM $str_table";
$temp_rs=mysql_query($sqlstr);
if(mysql_errno()>0)
{
echo "发生错误!\n$sqlstr";
exit;
}
$temp_row=mysql_fetch_array($temp_rs);
//************************************************ $this->recordcount=$temp_row[0];//这里如果有数据的话,结果为1;而不是记录总数//************************************************
$this->pagecount=ceil($this->recordcount/$this->pagesize);
if($this->cpage<1){$this->cpage=$this->pagecount;}
if($this->cpage>$this->pagecount){$this->cpage=1;}
$temp_abslocate=($this->cpage-1)*$this->pagesize;
$this->sql_limit=" LIMIT ".$temp_abslocate.",".$this->pagesize;
$this->prepage=$this->cpage-1;
$this->nextpage=$this->cpage+1;
}
//增加条件
function addCondition($str_table,$str_con)
{
$sqlstr="SELECT * FROM $str_table";
$temp_rs=mysql_query($sqlstr);
if(mysql_errno()>0)
{
echo "发生错误!\n$sqlstr"."<br>";
echo mysql_error();
exit;
}
$temp_row=mysql_fetch_array($temp_rs);//***************************************************
$num = mysql_num_rows($temp_rs);
$this->recordcount=$num;
//*************************************************** $this->pagecount=ceil($this->recordcount/$this->pagesize);
if($this->cpage<1){$this->cpage=$this->pagecount;}
if($this->cpage>$this->pagecount){$this->cpage=1;}
$temp_abslocate=($this->cpage-1)*$this->pagesize;
$this->sql_limit=" LIMIT ".$temp_abslocate.",".$this->pagesize;
$this->prepage=$this->cpage-1;
$this->nextpage=$this->cpage+1;
}
//$this->pagesize=$default_pagesize;
$this->pagesize=10;==>
$this->pagesize=$default_pagesize;
重出江湖了?
工作如何?
for($k=$startp;$k<=$start+$page*$pagesize+1;$k++)
{
echo mysql_result($query,$k,fieldname);
}用上面这种形式就可以啦!