多个while循环 本帖最后由 ph221 于 2009-12-15 17:05:15 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 while ($row = mysql_fetch_row($result)) {while($rs=mysql_fetch_array($result)){ echo "<tr>\n"; for($i=0;$i<count($row);$i++){ echo "<td>".$row[$i]."</td>"; } echo"<td><a href=modify.php?id=".$rs['ID'].">Update</a></td><br>"; } } 应改为:while ($row = mysql_fetch_row($result)) { echo "<tr>\n"; for($i=0;$i<count($row);$i++){ echo "<td>".$row[$i]."</td>"; } echo"<td><a href=modify.php?id=".$row['ID'].">Update</a></td><br>"; } } $sql = "SELECT * FROM `bios` ORDER BY id DESC";$result = $this->query ( $sql );while ( $row = $this->fetchArray ( $result ) ) { $data [] = $row;}foreach($data as $d){ echo "<tr><td>$d['SMANUFACTURER']</td> <td>$d['SMODEL']</td> <td>$d['SSN']</td> <td>$d['TYPE']</td> <td>$d['BMANUFACTURER']</td> <td>$d['BVERSION']</td> <td><a href='modify.php?id=".$d['ID']."'>Update </a></td></tr>";} while ($row = mysql_fetch_row($result)) { echo " <tr>\n"; for($i=0;$i <count($row);$i++){ echo " <td>".$row[$i]." </td>"; } echo" <td> <a href=modify.php?id=".$row['ID'].">Update </a> </td> <br>"; } } <?php$db = mysql_connect("localhost", "root","123456");mysql_select_db("el",$db);$result = mysql_query("SELECT * FROM bios",$db);echo "<table border=0>\n"; echo "<tr>\n"; while ($field = mysql_fetch_field($result)) { echo "<td>".$field->name."</td>\n"; } while($rs=mysql_fetch_array($result, MYSQL_ASSOC)){ echo "</tr>\n"; echo "<td>".$rs[字段名]."</td>"; echo"<td><a href=modify.php?id=".$rs['ID'].">Update</a></td>"; } } echo "</table>\n"; mysql_free_result($result); ?> 新手求助,需下载一个Zend Studio 7.0汉化包,分不够? 关于discuz添加好友的问题,请帮忙,谢谢! 关于php生成静态页面的疑惑 PHP模拟POST上传图片 积分处理 我的网站出错了帮看看 二次开发中遇到的问题,求解 急求软件项目文档模板!!! Linux服务器里的Cron 一个php人员的疑惑,大牛们请指点 请问CMS博客系统的API接口怎么写 <input type="file"/>
while($rs=mysql_fetch_array($result)){
echo "<tr>\n";
for($i=0;$i<count($row);$i++){
echo "<td>".$row[$i]."</td>";
}
echo"<td><a href=modify.php?id=".$rs['ID'].">Update</a></td><br>";
}
}
应改为:
while ($row = mysql_fetch_row($result)) {
echo "<tr>\n";
for($i=0;$i<count($row);$i++){
echo "<td>".$row[$i]."</td>";
}
echo"<td><a href=modify.php?id=".$row['ID'].">Update</a></td><br>";
}
}
$result = $this->query ( $sql );
while ( $row = $this->fetchArray ( $result ) ) {
$data [] = $row;
}foreach($data as $d){
echo "<tr><td>$d['SMANUFACTURER']</td> <td>$d['SMODEL']</td> <td>$d['SSN']</td> <td>$d['TYPE']</td> <td>$d['BMANUFACTURER']</td> <td>$d['BVERSION']</td> <td><a href='modify.php?id=".$d['ID']."'>Update </a></td></tr>";
}
echo " <tr>\n";
for($i=0;$i <count($row);$i++){
echo " <td>".$row[$i]." </td>";
}
echo" <td> <a href=modify.php?id=".$row['ID'].">Update </a> </td> <br>";
}
}
echo "<table border=0>\n";
echo "<tr>\n";
while ($field = mysql_fetch_field($result)) {
echo "<td>".$field->name."</td>\n";
}
while($rs=mysql_fetch_array($result, MYSQL_ASSOC)){
echo "</tr>\n";
echo "<td>".$rs[字段名]."</td>";
echo"<td><a href=modify.php?id=".$rs['ID'].">Update</a></td>";
}
}
echo "</table>\n";
mysql_free_result($result);
?>