菜鸟问题：多选框问题

Question

$numrows = mysql_num_rows($result);-------------------------while($numrows = mysql_num_rows($result))

Answer 1

另外，你的复选框没有值。
/***
<td align="left" style="font-size: 12px; cursor: default"><input type="checkbox" name="roleadd[]" >&nbsp;<? echo $s[funcname]; ?></td>**/

Answer 2

你应该把这个角色所有的功能id从数据库中取出来，组成数组，在每一个功能的复选框进行判断该功能id是否在那个数组里也存在，存在的话就设为选中。

Answer 3

include("../include/conn.inc");
                                $sql = "select * from function order by moduleid ASC";
                                mysql_query("SET NAMES 'GBK'");
                                $result = mysql_query($sql);
                                //$data=mysql_fetch_array($result);
                                $numrows = mysql_num_rows($result);
                                $i=1;
                                if($numrows>0)
                                {
                                for($rows=0;$rows<$numrows;$rows++)
                                {
                                $s = mysql_fetch_array($result);
                               ?>
                               <td align="left" style="font-size: 12px; cursor: default"><input type="checkbox" name="roleadd[]" value="<? echo $s[innerId]; ?>" <?$sql = "select * from rolefunc where funcid='".$funcid."' and roleid='".$_GET[roleid]."'";
                                mysql_query("SET NAMES 'GBK'");
                                $result = mysql_query($sql);
                                if(!$result)
                                {
                                 echo mysql_error();
                                }
                                $numrows = mysql_num_rows($result);
                                if ($numrows>0)
                                {
                                ?>checked<?}?>>&nbsp;<? echo $s[funcname]; ?></td>
                               <?
                               if((is_int($i/5)))
                               {
                                echo "</tr><tr>";
                               }
                               $i++;
                               }
                               }
                               mysql_close($connect);
                               ?>
在for循环里面呀？

Answer 4

zeroleonhart帮我看看，我用数组但还是不对，都没选中，帮我看看,谢谢！
<?
                               include("../include/conn.inc");
                               $sql = "select * from rolefunc where roleid='".$_GET[roleid]."'";
                                mysql_query("SET NAMES 'GBK'");
                                $result = mysql_query($sql);
                                if(!$result)
                                {
                                 echo mysql_error();
                                }
                                $numrows = mysql_num_rows($result);
                                if ($numrows>0)
                                {
                                  for($rows=0;$rows<$numrows;$rows++)
                                {
                                $y[$rows]= mysql_fetch_array($result);
                                }
                                }                                $sql = "select * from function order by moduleid ASC";
                                mysql_query("SET NAMES 'GBK'");
                                $result = mysql_query($sql);
                                //$data=mysql_fetch_array($result);
                                $numrows = mysql_num_rows($result);
                                $i=1;
                                if($numrows>0)
                                {
                                for($rows=0;$rows<$numrows;$rows++)
                                {
                                $s = mysql_fetch_array($result);
                               ?>
                               <td align="left" style="font-size: 12px; cursor: default"><input type="checkbox" name="roleadd[]" value="<? echo $s[innerId]; ?>" <? if (in_array($s[innerId],$y)){?>checked<?}?>>&nbsp;<? echo $s[funcname]; ?></td>
                               <?
                               if((is_int($i/5)))
                               {
                                echo "</tr><tr>";
                               }
                               $i++;
                               }
                               }
                               mysql_close($connect);
                               ?>