就是说下拉列表框怎么样实现?
$sql="select *from aa";
$result=$link->query($sql);
while($rs=$result->fetch_array()){
echo <<<BIAODAN
<form action="" method="post" name="form1" >
<input type="text" name="" value=$rs[1] />
<select name=''>
BIAODAN;
$sqlpn="select * from bb ";
$resultpn=$link->query($sqlpn);
while($rspn=$resultpn->fetch_array()){ //此处嵌套的while语句没有执行啊,如果数据量大怎么操作啊
echo "<option name='' value='{$rspn[0]}'>-- {$rspn[1]}</option>";
}
echo <<<BIAODAN
</select>
<input type="submit" value="修改" name="modify" />
</form>
BIAODAN;
}
$sql="select *from aa";
$result=$link->query($sql);
while($rs=$result->fetch_array()){
echo <<<BIAODAN
<form action="" method="post" name="form1" >
<input type="text" name="" value=$rs[1] />
<select name=''>
BIAODAN;
$sqlpn="select * from bb ";
$resultpn=$link->query($sqlpn);
while($rspn=$resultpn->fetch_array()){ //此处嵌套的while语句没有执行啊,如果数据量大怎么操作啊
echo "<option name='' value='{$rspn[0]}'>-- {$rspn[1]}</option>";
}
echo <<<BIAODAN
</select>
<input type="submit" value="修改" name="modify" />
</form>
BIAODAN;
}
CREATE TABLE `aa` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(32) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;INSERT INTO `aa` VALUES (1, 'aa');
INSERT INTO `aa` VALUES (2, 'bb');
INSERT INTO `aa` VALUES (3, 'cc');
CREATE TABLE `bb` (
`id` int(4) NOT NULL default '0',
`name` varchar(32) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `bb` VALUES (1, '11');
INSERT INTO `bb` VALUES (2, '22');
INSERT INTO `bb` VALUES (3, '33');
$resultpn=$link->query($sqlpn);
应该存入一个数组再foreach