多个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); ?> 江湖救急,急用啊,各位大侠。 求一段代码解释 PHP MYSQL 救命呀!!!! YII怎么做新闻列表中显示分类名 设置.htaccess 禁止访问网站根下面的某个php文件 在使用nginx+php-cgi配置的php欢姐中,出现这个错误,请问怎么解决啊。 大家有没谁做过“充值系统”的,能不能说说思路! php混淆解密 谁能帮我下?顺便教我方法 php微信开发实现微网站定位 win版MAMP安装之后phpinfo无法显示本地文件夹中的文件 请问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);
?>