$sql=”select id,name from shoping_type”; $rs=mysql_query($sql); $i=1; $j=mysql_num_rows($rs); while(list($id,$name)=mysql_fetch_row($rs)) { ?>
|
if($i%12==0) { echo “
“; } $i++; } ?>
另一种循环
$sql_shoping_type=”select id,name,img from shoping_type order by id”; $rs_shoping_type=mysql_query($sql_shoping_type); $j=1; while(list($id,$name,$img)=mysql_fetch_row($rs_shoping_type)) { ?>
……………………………………………………………………… if($j%3==0) { ?>
} $j++; } ?>
5:根据一个字段进行数据库读取
$sql1=”select img,url from img_news where id=1″; $rs_news=mysql_query($sql1); while(list($img,$url)=mysql_fetch_row($rs_news)) { ?>
$sql=”select id,product_name from product where 1=1″; if(trim($_POST[”productname”])!=””) { $sql.=” and product_name like '%”.trim($_POST[”productname”]).”%' order by id desc”; } elseif(trim($brand_name)!=””) { $sql.=” and product_brand like '%”.trim($brand_name).”%' order by id desc”; } else { $sql.=” order by id desc”; } //echo $sql; $rs = mysql_query($sql); $pagesize = 15; $cnt = mysql_num_rows($rs); if($cnt==0) { echo “暂无数据”; exit; } $pagecount = ceil($cnt/$pagesize); if(!isset($pageno)) $pageno=1; if($pageno<1) $pageno = 1; if($pageno>$pagecount) $pageno = $pagecount; mysql_data_seek($rs,($pageno-1)*$pagesize) or die(“无法定位数据！”); $j=0; ?>
…………………………………内容循环部分 while(list($id,$product_name)=mysql_fetch_row($rs) and $j < $pagesize) { ?>
