$num=mysql_num_rows($result1);
$pagesize=10;
$pages=$num/$pagesize;
$correct=($correctpage<=0)?0:$correctpage;
$correct=($correctpage>$pages)?$correctpage:$pages;
$offset=$correctpage*pagesize;
while(--$offset>0)
$row1=mysql_fect_row($result1);
$i=1;
while($row1=mysql_fetch_array($result1))
{
$data = $row1["bin_data"];  
$type = $row1["filetype"]; 
$filename = $row1["filename"]; 
$description = $row1["description"]; 
if($count++>$pagesize)
break;
}

解决方案 »

  1.   

    $result1= mysql_query("select * from ccs_image where upicid ='$user_id'");
    //$row1=mysql_fetch_array($result1);
    $numperpage=15;
    if($curnum=="")
    $curnum=1;
    for($i=0;$i<$curnum;$i++)
    $row1=mysql_fetch_array($result1);
    for($i=0;$i<15;$i++)
    {
    while(is_array($row1)){
    $data = $row1["bin_data"];  
    $type = $row1["filetype"]; 
    $filename = $row1["filename"]; 
    $description = $row1["description"]; 
    echo $data." ".$type." ".$filename." ".$description."<br>";
    $curnum++;
    $row1=mysql_fetch_array($result1);
    }
    }
    echo "<br><a href=\"".$PHP_SHEF."?curnum=".$curnum."\">下一页</a>"
      

  2.   

    傻子,用不着那么费劲!在select语句中加上LIMIT 0, 30就表示30条记录一页,从第0条开始!!
    $result1= mysql_query("select * from ccs_image where upicid ='$user_id' LIMIT 0, 30");
    $row1=mysql_fetch_array($result1);$data = $row1["bin_data"];  
    $type = $row1["filetype"]; 
    $filename = $row1["filename"]; 
    $description = $row1["description"];
      

  3.   

    有有问题$data = $row1["bin_data"];  是一张图片的数据,但显示出来的结果是:只有一张,如何都显示出来???
    以下是源代码:
    <?
     require("includes/connection.php"); 
     require("includes/tools.php"); session_save_path("111");
    session_start();if(!session_is_registered(user_id) || !session_is_registered(user_name))
    {
         echo "你的数据系统不能识别,请从新登陆!";
         //echo "<meta http-equiv=\"refresh\" content=\"0; url=../default.php\">";
     exit();
    }
    $result1= mysql_query("select * from ccs_image where upicid ='$user_id'");
    $row1=mysql_fetch_array($result1);$data = $row1["bin_data"];  
    $type = $row1["filetype"]; 
    $filename = $row1["filename"]; 
    $description = $row1["description"]; $num=mysql_num_rows($result1);
    $pagesize=10;
    $pages=$num/$pagesize;
    $correct=($correctpage<=0)?0:$correctpage;
    $correct=($correctpage>$pages)?$correctpage:$pages;
    $offset=$correctpage*pagesize;
    while(--$offset>0)
    $row1=mysql_fect_row($result1);
    $i=1;
    while($row1=mysql_fetch_array($result1))
    {
    echo $data;
    //echo $type;
    //echo $filename;
    //echo $description;
    if($count++>$pagesize)
    break;
    } ?>