php多行多列分页? 我现在遇到一个问题,一个记录集现在是多行多列显示,如何实现多行多列分的效果页呀。谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 if ($query) $query=stripslashes($query);else{ //if ($level=='3') $query=" 1=1 "; //else // $query=" 1<>1 ";}if ($query){ if ($pageList) { $temp=($pageList-1)*$RPP; $LIMIT="LIMIT $temp,$RPP"; } else $LIMIT="LIMIT 0,$RPP"; if($order) $orderby="ORDER BY $ID ASC"; else $orderby="ORDER BY ID desc "; $sql="select distinct(ID) from downloadlog where $query"; $result=mysql_query($sql) or die(mysql_error()."<br>source:$sql"); $TOTAL=mysql_num_rows($result); //echo $sql; $sql2="SELECT * FROM downloadlog where $query $orderby $LIMIT"; //echo $sql2; //die; //$sql2="select filelist.*,user.userName from filelist,user where filelist.userID=user.userID and $query $orderby $LIMIT"; $result2=mysql_query($sql2) or die(mysql_error()."source:$sql2"); $NUM=mysql_num_rows($result2); if($RPP) $pageTotal=ceil($TOTAL/$RPP); else $pageTotal=1; for ($i=1;$i<=$pageTotal;$i++) { $selected=($pageList==$i)?"selected":""; $list2.="<option value='$i' $selected>Page $i</option>\n"; } $record=""; $col=0; while ($row=mysql_fetch_array($result2)) { if($col==0) $record.="<tr bgcolor='#FFFFFF' align='center' onMouseOver=\"bgColor='#eef6ff'\" onMouseOut=\"bgColor='#FFFFFF'\">"; $record.="<td>".out_code("clientName","clienttemplate","ID='".$row[clientID]."'")."</td>"; $record.="<td>$row[fileID]</td>"; $record.="<td>".out_code("Name","filelist_detail","ID='".$row[fileID]."'")."</td>"; $record.="<td>$row[downloadDate]</td>"; $record.="<td>$row[ip]</td>"; $col++; if ($col==2) { $record.="</tr>"; $col=0; } } if ($col<>0) { $record.="<td colspan='6'></td>"; $record.="</tr>"; }} 抄了個樣例,HTML骨架自己加上去 PHP+XML 留言板引用留言功能 大数据量的查询网站 新手求指教!网页的排版问题,部分图片被挡住了 sql语句发短信,代码公开 php 的json_decode函数怎么解决单引号啊 PHP连接MYSQL的问题 PHP + Javascript 在Yahoo Map上显示Flickr 照片 php 获取网页内容不完整 100分求解 csdn用的是什么字体样式怎么怪怪的.... 奇怪,在php3运行的好好的程序怎么到php4有问题了? Mantis提交问题时看不见项目的说明?? 急救,在线等解决
$query=stripslashes($query);
else
{
//if ($level=='3')
$query=" 1=1 ";
//else
// $query=" 1<>1 ";
}
if ($query)
{
if ($pageList)
{
$temp=($pageList-1)*$RPP;
$LIMIT="LIMIT $temp,$RPP";
}
else
$LIMIT="LIMIT 0,$RPP";
if($order)
$orderby="ORDER BY $ID ASC";
else
$orderby="ORDER BY ID desc ";
$sql="select distinct(ID) from downloadlog where $query";
$result=mysql_query($sql) or die(mysql_error()."<br>source:$sql");
$TOTAL=mysql_num_rows($result);
//echo $sql;
$sql2="SELECT * FROM downloadlog where $query $orderby $LIMIT";
//echo $sql2;
//die;
//$sql2="select filelist.*,user.userName from filelist,user where filelist.userID=user.userID and $query $orderby $LIMIT";
$result2=mysql_query($sql2) or die(mysql_error()."source:$sql2");
$NUM=mysql_num_rows($result2); if($RPP)
$pageTotal=ceil($TOTAL/$RPP);
else
$pageTotal=1;
for ($i=1;$i<=$pageTotal;$i++)
{
$selected=($pageList==$i)?"selected":"";
$list2.="<option value='$i' $selected>Page $i</option>\n";
}
$record="";
$col=0;
while ($row=mysql_fetch_array($result2))
{
if($col==0)
$record.="<tr bgcolor='#FFFFFF' align='center' onMouseOver=\"bgColor='#eef6ff'\" onMouseOut=\"bgColor='#FFFFFF'\">";
$record.="<td>".out_code("clientName","clienttemplate","ID='".$row[clientID]."'")."</td>";
$record.="<td>$row[fileID]</td>";
$record.="<td>".out_code("Name","filelist_detail","ID='".$row[fileID]."'")."</td>";
$record.="<td>$row[downloadDate]</td>";
$record.="<td>$row[ip]</td>";
$col++;
if ($col==2)
{
$record.="</tr>";
$col=0;
}
}
if ($col<>0)
{
$record.="<td colspan='6'></td>";
$record.="</tr>";
}
}